Hello all -

Im trying do a running total on the amount but its not functioning correctly.

Here's my data below. I have a Grouping on (EMPID)

   NAME      TAXID   POLICY    AMT
GH
D   KIM       3527    JKC74     144
D   KIM       3527    JKC74     716
D   MARSHALL 7896    JKC74     716
D   MARSHALL   7896   JKC74     144

GF    


How to achieve the Sum AMT as $860 on the Group footer?     
    NAME      TAXID   POLICY AMT


Output needed as



GF   KIM      3527    JKC74     $860      860

Edited by Nav522 - 11 Oct 2017 at 4:37am

I think it gives either one of the NAME because of the grouping.

For me doesn't matter which NAME it returns in GF Its the DISTINCT sum for the whole Group that is what i'm looking for. Makes sense?



Edited by Nav522 - 11 Oct 2017 at 4:54am

The TRANS ID

There are different amounts for each TRANS ID but the data backend returns multiple rows for the same amount.

Here it is the actual data

NAME          TID    TRANSID    POLICY    AMT
GH
D   KIM       3527     DU    JKC74     144
D   KIM       3527     DU    JKC74     144
D   KIM       3527     DU     JKC74     0
D   MARSHALL 7896     RO    JKC74     716
D   MARSHALL   7896     RO   JKC74     716

GF(POLICY)

I did a running total on the amount with evaluate on TRANS ID and reset on POLICY but im getting skewed SUM.


I tried a formula in evaluate AMOUNT<> Previous (AMOUNT) but still it doesn't add up
     





Edited by Nav522 - 11 Oct 2017 at 7:33am

Thanks that worked. But I have a second report where I have to capture a differences of two TRANSID
i.e. SUM(DU) and SUM(RO) and show the difference between them

So basically I have to show 716 - 144 = 562

But the RT includes the duplicates and giving me 1144. ANy workaround?

Edited by Nav522 - 11 Oct 2017 at 8:11am

That did it but where ever the difference between "RO" and "DU" is equal to 0. It is putting blank field instead on 0. Is there a way to suppress the whole row for that specific problem?

I tried Suppress formula on GF as DIFF = 0 but t doesn't work