This content has been marked as final.
Show 2 replies

1. Re: Calculating Month over Month Ratio every 6 months
Michel Caissie Aug 20, 2018 10:12 AM (in response to malvika.tripathi.0)Malvika,
is this what you are looking for.
I get the numbers with
if first() != 0 then
if ATTR( [Months] )%6 = 1 then SUM([Value]) / lookup(SUM([Value]), 1) end
end
Basically, except for the first month, for every 7th month (modulo 6 = 1) then divide the current value by the value of the precedent row.
Michel

Ratio_Calc(mc).twbx 27.0 KB


2. Re: Calculating Month over Month Ratio every 6 months
Deepak Rai Aug 20, 2018 10:24 AM (in response to malvika.tripathi.0)
Ratio_Calc.twbx 26.8 KB
