Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a variable to use in a straight table expression. For some reason when I use it, the value doesn't change for each dimension value, but when I take the same thing that I set the variable to and put that in the expression in the table, the values do change based on the dimension. This is what the variable is set to:
=if(GetSelectedCount([Production Date]) <> 1, '-',
if(count([App Flag]) < 1, '-',
num((count(distinct if([App Flag] = 'Yes', [ID Number]))/count(distinct [ID Number])),'#,##0.00%')))
Is there anything I can do to make the variable act as a chart expression?
Thank you
When you define the variable in variable overview, remove the equal sign in front of the expression
When you define the variable in variable overview, remove the equal sign in front of the expression