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

# How to use variable in  set analysis

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!!

• ###### Re: How to use variable in  set analysis

maybe this (if you always get 1 value for exclusive percentage with the dims tou're using)

=

if (    [Exclusive Percentage]>=\$(vTopBottomPercents)

and  [Exclusive Percentage] <= \$(vTOPAccomplishment),

avg(Aging_Hours_Dashboard*60)

)

• ###### Re: How to use variable in  set analysis

Hi,

yes!!!

It worked!!

Thanks a lot!!