Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
You might be able to make Above() work even with selections.... do you have an example where Above() is not working with selections?
if i make selection:
For me The AsOfTable is a Time field 'YYYY MMM'
What was the expression you used for accumulation?
Rangesum( Above(Sum({$<MonthDiff={'-1'}>} #MEASURE ) ,0, RowNo(total)))
Try this
Rangesum(Above(Sum({$<MonthDiff={'-1'}, AsOfMonth>} #MEASURE ) ,0, RowNo(total))) * Avg({$<MonthDiff={'-1'}>} 1)
Conceptually it is right and works.
But isn't what i'm looking for.
oh okay... but if it gives the right number, then why are you not looking for this