Thought I had it on the blog, but couldn’t find it….. Q&D way of getting a value of the previous row:
Use MSUM (MovingSum)
MSUM("F1 Revenue"."1-01 Revenue (Sum All)",2) - "F1 Revenue"."1-01 Revenue (Sum All)"
(Yeah I know there better ways :-) )
Till Next Time
Stijn found the original post on this subject: