cancel
Showing results for 
Search instead for 
Did you mean: 

Sum running total

Former Member
0 Kudos

I'm needing assistance with running totals.

I'm looking to accomplish this (1):

MRN INDate Balance TotalDue

1 10-07-2017 8.00 28.00

1 10-17-2017 20.00 28.00

2 10-04-2017 20.00 80.00

2 10-07-2017 20.00 80.00

2 10-18-2017 20.00 80.00

2 10-21-2017 20.00 80.00

3 10-17-2017 50.00 50.00

Can anyone assit me as I am new and learning? Thank you /G\

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Micheal,

1. Insert a Group on MRN field.

2. Create a formula with this code:

Sum({Balance}, {MRN})

3. Place the formula field on the details beside Balance field.

4. Suppress the Group Header/Footer.

-Abhilash

Answers (1)

Answers (1)

Former Member
0 Kudos

Perfect, just what I was looking for, Thank you so much.