Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Chart table where the first column is a cycle group (dimension). I am trying to hide/show some columns based on the option chosen in the cycle group.
I go to Presentation tab and use:
if(getcurrentfield([Product Cycle]) = 'Green')
It seems the group name is not recognized. [Product Cycle] is not recognized and shows as wrong when typing the expression.I have checked many times the spelling.
Can you help?
Your if statement isn't complete. It only contains the condition, not the true and false result expressions:
if(getcurrentfield([Product Cycle]) = 'Green',1,0)