1 Reply Latest reply on Nov 4, 2013 11:49 AM by philmodjunk

    To date total



      To date total


           Hello there, 


           I am creating an accounting database and I need to have two summary fields one would show the running total for the month and one showing the running total to date (when the list is pulled)

           How this be done



        • 1. Re: To date total

               How to do this would depend on the structure of the data in your table.

               The simplest possible solution is to define two summary fields and select the running total option. Then use the "restart totals when grouped by" option to restart your running total for each month.

               You can use the following calculation field as the "group by" field so long as you also include that field in your sort order:

               TransactionDate - Day ( TransactionDate ) + 1 // select Date as your result type.

               This calculation computes the date for the first day of the same month for all dates in that month/year.