Dear friends, I want to add a constraint to the left and right input values corresponding to the line items. If they exceed 100, an error will be reported. Is there any good way?
hi Case 1: Sum of left and right are greater that 100 you can create a line item of text format and then you can display desired error message and can apply conditional format as well. Case 2: Individual limits if entered greater than 100 also you can display error by creating line items. Screenshot for reference
Hope it helps.
Hi, you can sum both right and left values in 3rd line item(Number Format) if right+left >100% then 1 else 0, then use this 3rd line item as conditional formatting to highlight right and left fields.
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
Hi Community, I’m working with a hierarchical list structure in Anaplan: L1 Region (e.g., Asia, Europe) L2 Country (e.g., India, Pakistan) L3 Local Input (e.g., Mumbai, Lahore, Islamabad) Users are given selective access only at the L3 level (specific cities like Mumbai, Lahore, etc.) so they can input data at those…
As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (Jan–Aug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025. If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025…
