How to remove zero from line items in a module .I have applied filter but there some columns having Zero .
apply blank in format
when you say "remove" are you trying to hide the zero values for a line item in a module?
The screenshot above is only a formatting option which will display zero values as blank. In order to hide zero values, you need to create a filter on your column (line item > 0). If this filter is going to be used on dashboards, I recommend creating a separate Filter module with the same dimensions as your module where you want to apply the filter.
1. In the filter module, add a Boolean line item and write your filter condition (example: x >0 and/or y>0 etc.)
2. In the data module, apply the filter against the line item for which you want to hide zero values
3. If you have multiple line items with zero values, you'll need one boolean formatted line item filter for each column and create a final boolean line item that combines all the filter conditions using OR function
Hope this helps.
Hello Everyone, Our team is currently preparing for the requirements gathering phase of our 1st upcoming Anaplan implementation. To ensure that our design aligns perfectly with our business processes and effectively addresses our users' needs, we want to conduct a thorough discovery process. Could you please let us know if…
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…
