Dynamic Set Analysis

[c_pannese]

Hi All,

i've an issue with Set Analysis.

I have to calculate a Cumulative measure but i cannot use above function because it doesn't work correctly for me when i make selections.

The reference measure is

Sum( {$< MonthDiff={'-1'} >} #MEASURE)

i'm trying to use this formula for having cumulate:

Sum( {$< MonthDiff={'-1'} >} #MEASURE)  +

Sum({$<MonthDiff={">=0 <=$(=num(Month(AsOfMonth))-2)"}  #MEASURE)

The problem is that the string    <=$(=num(Month(AsOfMonth))-2)    doesn't work.

How can i write this for Set Analysis?

Thank you All.

[c_pannese]

i'll think about it!

thanks.

[sunny_talwar]

hahaha okay