help with formula

Hi,

I'm trying to create a function that divides two line items, but the second line item needs to be the value of the 8th month from the first line item. This is the function that I created.

'F01 Funding Breakdown'.Total Funding / IF MONTH(START()) = 1 THEN OFFSET('F01 Funding Breakdown'.Scaled New Originations, 8, 0) ELSE 0

I'm still not getting what I want with this function. please advise.

Thank you

Accepted answers

JaredDolich

@neg177

Cool. Like this? I would just create a third line item. It's a lot easier.

All comments

JaredDolich

@neg177

You have the best questions. Here's how I would approach this.

Instead of using the month(start()) equation which would have to be calculated at every cell, try using a system module that indicates which month is the first month.

You can set up a module that only uses the model calendar. Create a line item that is Boolean Formatted. Set the formula to find the first month. Call it "First Month". Then use that in your Line Item 2 formula, like this. The "8", by the way, can be a driver you set in another system module in case you need it to be more dynamic.

neg177

Wait Im kind of confused what the Boolean Line Item would be. Because I would want the formula to Divide the first Line Item by the Second Line Item, but the second line item needs to be the value eight months later. So for example If it was February, I would need to divide by the value in October. If it was March, I would need to divide by November's value...and so forth

JaredDolich

@neg177

Cool. Like this? I would just create a third line item. It's a lot easier.

neg177

Got it, I'm testing it out now. Thank you!

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…