Hi!
A question - can I suppress zeroes when I'm using a Column chart?
I saw that option in Waterfall.. but I guess it is the only one where I can do it?
And no options about handling Zeroes in other types of charts?
Thank you.
Hello @JoannaAn
Can you show us an xample?
Have you tried setting to zero format to Blank?
Another option is to set a filter to hide items with value 0 from the chart
@JoannaAn
You can try using an IF THEN ELSE statement in you data to return DIVIDE(0,0) if the data is a zero this will return a NA for all zeros which will not show on the final chart.
If you need to display this data in a grid on a page create a duplicate module and use this IF THEN ELSE and use this duplicate grid to feed your chart.
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…