Forum Discussion
aempa
9 years agoFrequent Visitor
Growth % in time events
Hello I have already calculated the salary expenses of my employees over time, with a formula that I show below. Now I want to calculate a growth rate of the salary expenses, over the years and t...
- 9 years ago
In your measure you try to sum up the column [Montante]. But for the totals you need to sum up the column [Salary Atual soma]
spuder
Resolver IV
9 years ago1950 is 102,63% of 1900 (1950*100/1900)
If you wish just the groth you have to divide by 100%
so the result would be 2,63%.
Or am I wrong with your needs?
aempa
9 years agoFrequent Visitor
Sorry, I am a little rookie on this.
I want to know the growth between January and February or 2012 and 2013.
In this moment, I have this results:
I can't link the date table because my "Salary atual soma" are influence negatively.
- spuder9 years ago
Resolver IV
In this scenario I would choose the following approach.
Using PREVIOUSMONTH() and PREVIOUSYEAR()