Calculating the difference from the previous row per company and year

Question

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 Answer

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.