Hi,
I'm trying to get a formula to retrieve the end of the month total of the line item. I know I need to use the END() function but not sure where to put it in my formula. my formula is below. Thank you
IF 'S01 Time Filter'.Allocate to new line item? THEN MIN('Barrowing Base (payment for prior day loans)' + Cash Collected + '(Cash Sweep to Wells)' + 'BALANCING FIGURE FOR x5000' + 'Interest Acct (x1001)' + '(Cash Sweep to Wells)' - Payments on Securitization + 'Collection Acct (x1000)', 'Barrowing Base (payment for prior day loans)' + Cash Collected + '(Cash Sweep to Wells)' + 'BALANCING FIGURE FOR x5000') ELSE 0