Forum Discussion

faustusxanthis's avatar
faustusxanthis
Frequent Visitor
3 years ago
Solved

Calculate value from previous month

Hello!    I am currently stuck with this problem and I can't seem to find the solution anywhere.    I currently have a table with 3 columns that look like this:     I would like to have ...
Tips and Tricks
Tutorial Requests
  • faustusxanthis's avatar
    faustusxanthis
    3 years ago

    I got it. I used LOOKUPVALUE. 

    =[Volume]- LOOKUPVALUE([Volume], [Reason], [Reason], [Month], PREVIOUSMONTH([Month]))
faustusxanthis's avatar
faustusxanthis
Frequent Visitor
3 years ago

I got it. I used LOOKUPVALUE. 

=[Volume]- LOOKUPVALUE([Volume], [Reason], [Reason], [Month], PREVIOUSMONTH([Month]))