Summing Running Total Fields?

[Jason2121]

I have created Running Total Fields for multiple Bank Accounts that had multiple transactions within a given period. This gave me a Current Balance at the end of the Period for each of the Accounts.

Now I am trying to get a Total Sum for all the Totals at the end of the period so I can match up with the GL Account for Cash. My subaccounts within the Cash Account represents each bank and this matches up. But I also need to show the Total Sum in the CR that matches the GL Account.

Doea anyone have any tips?

Jason

 

[vega83]

You cannot do runnig total on a running total, Only otherway is create a formula If field = "some value" then 1 else 0. Crate all the formulas with your various scenarios and then create other Totaformula =Banaccountformuaa1+Banaccountformuaa2+Banaccountformuaa3.
Now create a sum on running total on this.

 

[Jason2121]

Thanks, It worked

Jason