Percent growth between Rows
Is it possible to show the percentage change of each value based on the previous value (row)? That is, the change from week 30 to week 31, from week 31 to week 32, etc. in percent as an additional column?
0
Comments
Hi Marcel,
Yes - that should be possible.
Try this syntax:
(sum(d-1, 0, m1) - sum(d-1, -1, m1, 0)) / sum(d-1, -1, m1, 1) * 100
or
(sum(d-1, 0, m1) - sum(d-1, -1, m1, sum(d-1, 0, m1))) / sum(d-1, -1, m1, 1) * 100
The difference is how the first row should behave.
BR / Ole
Ok, i'm impressed. :) Works both, thanks for this!
Please sign in to leave a comment.