I am trying to have a calculation using a running total in a report. The object of the calculation is to take a beginning loan amount or savings account amount (depending on the group) and then subtract the Amount Disbursed from first the loan amount/savings amount and then the next Amount Disbursed from the previous end total.
Here is the formula we have so far (written in the query) and placed in the details section and Running Total over group:
IIf([LIP or Savings] = "LIP",([Initial Loan Amount]- [Amount Disbursed]),([Initial Savings Amount]- [Amount Disbursed]))
We were thinking of using an indexed field to use the Select/Case statement, but not sure how. Please help!!!
Here is the formula we have so far (written in the query) and placed in the details section and Running Total over group:
IIf([LIP or Savings] = "LIP",([Initial Loan Amount]- [Amount Disbursed]),([Initial Savings Amount]- [Amount Disbursed]))
We were thinking of using an indexed field to use the Select/Case statement, but not sure how. Please help!!!