How to dynamically subtract two last column values?

chrisboy68 — Mon, 02 May 2022 16:59:45 GMT

Hi, have SPL that generates months of data. I want subtract just the last two columns. The fields will change month to month, so I can't hard code.

Given the below sample, how can I get lastMonthDiff without hardcoding the field values? Thank you! Chris

Re: Dynamically Subtract Two Last Column Values

ITWhisperer — Mon, 02 May 2022 16:10:07 GMT

| foreach * [| eval diff=if(isnull(previous),null(),previous-'<<FIELD>>') | eval previous='<<FIELD>>']

chrisboy68 — Mon, 02 May 2022 17:28:59 GMT

Awesome, thank you!