1 Reply Latest reply: Feb 12, 2018 5:26 AM by Filip Kamieniecki RSS

    Variables with rank function in set analysis

    Filip Kamieniecki

      Hi All,

       

      I would like to use variable which stores rank function in set analysis.

       

      This is the variable which I want to use in Set Analysis:

       

      vVariable1=if((rank(fabs($(vABC)),4,2))=1,dim1)

       

      where vABC keeps the Pick function with some variables.

       

      This is the whole formula:

       

      Count({<dim1={$(vVariable1)}>}distinct measure1)

       

      and it doesn't work.

       

       

      When I put in the table dim1 and $(vVariable1) it shows data correctly.

       

      Do you have any idea what's wrong?

       

      Thanks.