Hi,
Is there an option to suppress zeroes in a module so all the cells that have 0 or blank as values can be hidden?
Thanks
Megha
@Megha27
I assuming you have a timescale, so the easiest way is to create a Boolean line item named Not Zero? with the formula being Data <> 0. You want that in case you have offsetting line items. Create another line item, Boolean formatted , this time remove Time from the Applies To (this will create a subsidiary view) for that line item. The formula should be TimeSum(Not Zero?, -1000,1000, ANY) and you can filter on this. The -1000 is the start date, the 1000 is the end date, and the ANY is the summary which works with the Boolean.
see if that works as I am doing this from memory and not testing it out.
Rob
@Megha27 Why ain't using Filter option to filter all zero data?
And you can save that as a view.. so it will be like ready to use non-zero table / module
@Megha27 In Anaplan there is not a specific setting to hide/suppress the zero/blank cells when you publish data in dashboards/NUX pages. You need to use the normal filtering options also by creating boolean line-items as @rob_marshall suggested.
However, there is an option for export actions: "Omit Empty rows" which can be considered similar to suppressing blank/zero rows.
Hope it helps
Alex
To avoid adding a line item to the module and increasing the number of cells, I have inserted a boolean in the SYS cube of the product; for example
Has Lot Expiration? = TIMESUM ('DAT40 Inventory Lot Expiration'. 'Inventory (Planning)') <> 0
and then I filtered on the UX.
@matteo1972 Using the timesum on the real line-item data you have the risk to suppress the rows that have data in a month but are reversed in another month.
At totals, the numbers are not changed, but looking at every month you could have different results.
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.…
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…
