2 Replies Latest reply: Mar 13, 2016 6:01 AM by Inna Shnaiderman RSS

    How to use variable in  set analysis

    Inna Shnaiderman

      Hi,

      I have the following calculated expression in my Set Analysis called [Exclusive Percentage].

      Then i have two variables:

      vTopBottomPercents

      and

      vTOPAccomplishment


      I want to show calculation avg(Aging_Hours_Dashboard*60) if [Exclusive Percentage] is between

      vTopBottomPercents

      and

      vTOPAccomplishment


      I made the following expression:

       

      = if ([Exclusive Percentage] = {">=$(='$(vTopBottomPercents)')<$(='$(vTOPAccomplishment)')"}, avg(Aging_Hours_Dashboard*60))

       

      but it does not work.

       

      Please help urgently!!