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

Accepted answers

All comments

andrewtye

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!

rob_marshall

@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)

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…