1 Reply Latest reply: Mar 10, 2017 1:34 PM by Sunny Talwar RSS

    Variable is static in straight table?

    Matt Maino

      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