Where to put the END() Formula/Trying to get a formula to retrieve the end of the month total

Highlighted
Regular Contributor

Where to put the END() Formula/Trying to get a formula to retrieve the end of the month total

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

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Where to put the END() Formula/Trying to get a formula to retrieve the end of the month total

Hi @neg177 

Presume that your module is day dimensioned? If so in the module that has the output you'll need to do a lookup against your other module so it's something like Line Item[Lookup: date] where date is either end() of time dimension or end(Period) where period is a time formatted line item

You could always put the summary settings to closing balance which would I think give you much the same answer...

Hope that helps!

Highlighted
Master Anaplanner/Community Boss

Re: Where to put the END() Formula/Trying to get a formula to retrieve the end of the month total

@neg177 

 

First, I would create a new line item that is summing those line items up so it is not doing the sum in the IF statement.  Then, I would use the function MonthValue (link)