2 Replies Latest reply on Mar 22, 2014 7:22 PM by amtrakpdx

    Running total, bottom to top

    amtrakpdx

      Title

      Running total, bottom to top

      Post

           Novice here; please be VERY specific with answers.

           Table has fields of: Date, Amt and Running Total

           What I want: When I sort based on date with newest date at the top of my portal display, I'd like the most recent running total amount to ALSO be at the top.

           Currently my portal shows the the latest balance at the bottom of the list regardless of the date sort I perform.

           TIA for any assistance.

           Sam

        • 1. Re: Running total, bottom to top
          philmodjunk

               This question intrigued me so I did a little experiment and got it to work.

               Let's say that the field from which you want to calculate your reverse order running total is called "Value".

               Define a summary field, sTotal as the Total of Value.

               Define a second summary field, sRunningTotal as the Total of Value, but specify that it be a running total.

               Define a calculation field, cReverseRunningTotal as:

               sTotal - sRunningTotal + Value

               And this calculation field will produce your reverse order running total.

          • 2. Re: Running total, bottom to top
            amtrakpdx

                 Phil,

                 This worked wonderfully!

                 Thanks for being there,

                 Sam