topic Re: Where to put the END() Formula/Trying to get a formula to retrieve the end of the month total in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/Where-to-put-the-END-Formula-Trying-to-get-a-formula-to-retrieve/m-p/90400#M20214
<P>Hi <LI-USER uid="37589"></LI-USER> </P><P>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</P><P>You could always put the summary settings to closing balance which would I think give you much the same answer...</P><P>Hope that helps!</P>Tue, 10 Nov 2020 15:36:26 GMTandrewtye2020-11-10T15:36:26ZWhere to put the END() Formula/Trying to get a formula to retrieve the end of the month total
https://community.anaplan.com/t5/Anaplan-Platform/Where-to-put-the-END-Formula-Trying-to-get-a-formula-to-retrieve/m-p/90393#M20210
<P>Hi,</P><P> </P><P>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 </P><P>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</P>Tue, 10 Nov 2020 14:57:51 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Where-to-put-the-END-Formula-Trying-to-get-a-formula-to-retrieve/m-p/90393#M20210neg1772020-11-10T14:57:51ZRe: Where to put the END() Formula/Trying to get a formula to retrieve the end of the month total
https://community.anaplan.com/t5/Anaplan-Platform/Where-to-put-the-END-Formula-Trying-to-get-a-formula-to-retrieve/m-p/90400#M20214
<P>Hi <LI-USER uid="37589"></LI-USER> </P><P>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</P><P>You could always put the summary settings to closing balance which would I think give you much the same answer...</P><P>Hope that helps!</P>Tue, 10 Nov 2020 15:36:26 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Where-to-put-the-END-Formula-Trying-to-get-a-formula-to-retrieve/m-p/90400#M20214andrewtye2020-11-10T15:36:26ZRe: Where to put the END() Formula/Trying to get a formula to retrieve the end of the month total
https://community.anaplan.com/t5/Anaplan-Platform/Where-to-put-the-END-Formula-Trying-to-get-a-formula-to-retrieve/m-p/90404#M20217
<P><LI-USER uid="37589"></LI-USER> </P><P> </P><P>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 (<A href="https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/MONTHVALUE.html" target="_self">link</A>)</P>Tue, 10 Nov 2020 15:48:39 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Where-to-put-the-END-Formula-Trying-to-get-a-formula-to-retrieve/m-p/90404#M20217rob_marshall2020-11-10T15:48:39Z