Help with a grid

I want to create a rolling column of data in a grid that is dependent on the data of previous columns… its for year over year sales information. If I can figure it out from the screenshot example, I would then like to apply that same logic to the QTY column… so I can show easily the difference between each year’s QTY and Total Sales.

I have included a screen shot of what I am trying to accompish via a Scriptcase Grid.
Even just pointing me in the right direction would be very helpful if you have ANY suggestions.

Thank you!

Hi, create a field difference and in OnRecord, save in a variable the value of the previous record and create a formula {difference}= {total}- [var];

Or use the acumulator option.

1 Like