Skip to Content

How to calculate percentage change for reverse chronological order

Feb 14, 2017 at 03:20 AM


avatar image
Former Member


Hi all

I am able to calculate the percentage change from year to year using Previous() and/or Relativevalue() for the first table. But when I sort the years in reverse chronological order, the formula messes up. Any ideas on how to fix this? Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers