Forum Discussion

aempa's avatar
aempa
Frequent Visitor
9 years ago
Solved

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...
Need Help
  • aempa's avatar
    aempa
    9 years ago

    Thank you spuder. I'm sorry to have so many questions.

     

    I Tried but the result are 0%, any tips?

     

  • spuder's avatar
    spuder
    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's avatar
spuder
Icon for Resolver IV rankResolver IV
9 years ago

In this scenario I would choose the following approach.

 

Using PREVIOUSMONTH() and PREVIOUSYEAR()

 

aempa's avatar
aempa
Frequent Visitor
9 years ago

Thank you spuder. I'm sorry to have so many questions.

 

I Tried but the result are 0%, any tips?

 

  • spuder's avatar
    spuder
    Icon for Resolver IV rankResolver IV
    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]

    • aempa's avatar
      aempa
      Frequent Visitor
      9 years ago

      Thank you for your patience spuder. Your solution was perfect.