11 Replies Latest reply: Mar 28, 2018 4:46 AM by Sunny Talwar

# Dynamic Set Analysis

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.

• ###### Re: Dynamic Set Analysis

What is the value in AsOfMonth?

If you put the expression num(Month(AsOfMonth))-2

in a text box, do you get the numeric value?

• ###### Re: Dynamic Set Analysis

For me The AsOfTable is a Time field 'YYYY MMM'

• ###### Re: Dynamic Set Analysis

You might be able to make Above() work even with selections.... do you have an example where Above() is not working with selections?

• ###### Re: Dynamic Set Analysis

if i make selection:

• ###### Re: Dynamic Set Analysis

What was the expression you used for accumulation?

• ###### Re: Dynamic Set Analysis

Rangesum( Above(Sum({\$<MonthDiff={'-1'}>}  #MEASURE ) ,0, RowNo(total)))

• ###### Re: Dynamic Set Analysis

Try this

Rangesum(Above(Sum({\$<MonthDiff={'-1'}, AsOfMonth>}  #MEASURE ) ,0, RowNo(total))) * Avg({\$<MonthDiff={'-1'}>} 1)

• ###### Re: Dynamic Set Analysis

Conceptually it is right and works.

But isn't what i'm looking for.

• ###### Re: Dynamic Set Analysis

oh okay... but if it gives the right number, then why are you not looking for this

• ###### Re: Dynamic Set Analysis

i'll think about it!

thanks.

• ###### Re: Dynamic Set Analysis

hahaha okay