How to hide columns using formula and which formula to use. For example, if my column value is equal to 0, it should automtically hide those columns and if cell value if equal to 1 then it should display the values of that column.
@moloysingha
You don't need to use a formula as such as you need to use a filter
I would, however, recommend having a separate module to check for 0s and 1s in a boolean flag (this is the most efficient filter type to use.
There is a lot of information in filters here:
https://help.anaplan.com/anapedia/Content/Modeling/Working_with_Data/Filter.html
I hope this helps
David
Hi ALL, I'm using Product Category, Product Line, and Budget Type to generate a unique Code for a list. The display string is generated as: Product Category & "_" & Budget Type & "_" & Product Line. The Code is currently generated using: LEFT(Display String, 60) The issue is that Product Category and Product Line contains…
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
Why in my model output is blank, after send explainability data.
