My VISA acc't Layout records transactions summarized by Month in a Sub-summary Part (trailing). Four Fields match the data in the VISA statement: "Previous Balance", "Payments & Credits", "Purchases & Other Charges" and "New Balance."
The "Payments" are Credits and the "Purchases" are Debits.
The Layout is sorted by c_DateSort, the equation (below) provided by philmodjunk, because the VISA Statement starts each Month on the 5th and ends on the next Month's 4th.
To satisfy the "Previous Balance" a Script or Equation is needed, like: GoTo "previous Month", "last Record", Field "s_running_balance", copy and paste in the current Month's "Previous Balance" Field.
Each Record has the flwg Fields: n_ser_nbr, d_date, t_payee, t_category_t_memo, n_debit, n_credit, s_running_balance.
Sub-summary Part (leading):
The Sub-summary Part (trailing) Fields are: VISA Statement Month of: c_DateSort (Month name); Previous Balance (to be determined); Payments & Credits: s_subtotal_credits; Purchases & Other Charges: s_subtotal_debits; and New Balance: s_running_balance.
The cDateSort equation provided by philmodjunk,is:
Calculation = Let ( [ dt = ( d_date) ;
dy = Day ( dt ) ;
m = Month ( dt ) ] ;
Date ( m - ( dy < 5 ) ; 1 ;
Year ( dt ) )
) // let
Ergo, needed is the Script or Equation to satisfy the "Previous Balance" Field. Any help provided will be greatly appreciated.