Calculating the difference from the previous row per company and year

[Mwatts23]

Hi,

Good day!

I hope someone can help me on what formula is needed to get the True Value per row.

The explanation in column E describes how the True Value is calculated.

Please let me know, if you need additional information on my query. Thank you!

Best regards,

Mike

[Luke_C · Accepted solution]

Hi @Mwatts23 

You would use the multirow formula tool. I created a year field to help, but grouping by company/year you can use a formula to do this logic, checking if it's the first instance (row-1 being null), otherwise subtracting the previous row's snapshot.

[Mwatts23]

Thank you @Luke_C  for looking into my query. It is the process and result that I need. Amazing! 

Best,

Mike