Accumulating Sum

[MPH]

I am trying to accumulate total everything works fine until the net billing becomes 0,  having trouble understanding why the cumulative total keeps increasing even though net billing is 0

See below

[Ksrinivasan]

hi,

i don't know why its keep running,

but you can try IF condition

IF(Net Billing>'0',RangeSum(Above(TOTAL Sum(NET_BILLING_AMT),0.RowNo(TOTAL))),'')

Ksrinivasan