Forum Discussion

iskruger's avatar
iskruger
Frequent Visitor
9 years ago
Solved

percent change

Hello,   Could use some help in creating a measure that will properly compute the percent change for the table below. As you can see, I'm having a problem computing accurate percentages and would ...
  • iskruger's avatar
    iskruger
    9 years ago

    Hi Birdjo,

     

    Thank you very much!

Birdjo's avatar
Birdjo
Resolver II
9 years ago

Hello, I believe this will help you:

Growth % = (DIVIDE(SUM(This Year),SUM(Last Year))-1)*100

 

P.S.: You can skip multiplying it by 100 and just format it as a percentage from the Modeling tab. 

 

iskruger's avatar
iskruger
Frequent Visitor
9 years ago

Hi Birdjo,

 

Thank you very much!

  • Birdjo's avatar
    Birdjo
    Resolver II
    9 years ago

    Btw I think you chose your own post as a solution.