Help with variable within set analysis

[Meg00]

Hello,

Example of current set analysis:

=num(sum({$<Lev = {1},PeriodCounter ={">=$(#=max(PeriodCounter)-11<=$(#=max(PeriodCounter))"},period=>}Netsales)*-1/1000000,'# ##0')

I want to store the red part (rolling 12) in a variable. But how do I then use that variable correct? I can't get the right syntax.

Thanks,

Meg

[jaibau1993 · Accepted solution]

Hi!

You should create the variable vSetExpression with the following content

PeriodCounter ={">=$(#=max(PeriodCounter)-11<=$(#=max(PeriodCounter))"},period=

And then you invoque it as follows

=num(sum({$<Lev = {1},$(vSetExpression )>}Netsales)*-1/1000000,'# ##0')

Let me know your doubts! Regards,

Jaime.

[Meg00]

Thank you, was more simple than I thought:)