Crystal Report Running Totals

Question

I am working in the Crystal Report Environment (IDE).

 

 

I am trying to create a running variable and substract from the total base upon an condition.

 

For example: If Total is greater than 80, take the total and subtract 80 from the total. If we apply that condition below. The difference will be 10.

 

90 is greater than  80. So there for 90-80 = 10

 

 

ColorId     ColorItem  ColorTotal

1                     red                30

2                     blue              20

3                     black             40

--------------------------------------

                         Total =       90