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.
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
