Running Total

[smilingjohn]

Hi All,
I have a table which has following fields(Columns)
Date,Cdefect,CIDefects and Odefects.
As shown in the below screenshot.

Now i have to come up with a output table which should show me running total.
where the Odefect will be added to Cdefect and the result will be Subracted from CIDefect and provides the output in Total
this is how it repeats.
Below is the screenshot of the Out put .

Can you please help me in achieving this

Thanks in Advance

[Arthur_Fong · Accepted solution]

There you go:

Build a new column (Total) at script level.

Refer attached qvw for the logic using peek() function.

Thanks and regards,

Arthur Fong