Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the attached example, I need to calculate for each day of the dimension five days back and compare them with five days previous to the first 5.
For example, for the day 30/09 day should add 30,29,28,27,26 / 09 and compare them with the days 25,24,23,22,21 / 09.
In the example there are more clarification.
Regards.
May be this:
=RangeSum(Above(Sum(Imp), 0, 5)) - RangeSum(Above(Sum(Imp), 5, 5))
May be this:
=RangeSum(Above(Sum(Imp), 0, 5)) - RangeSum(Above(Sum(Imp), 5, 5))