How to fill a line item recursively

PauloM · 2023-04-06T15:34:31+00:00

There was an error rendering this rich post.

Hi!

I have one module where one of the line items is my inventory amount and on the columns I have a list where I put diferent fiscal years (note that I cannot use the formula PREVIOUS() because this module is not connected with Time, and I can't connect it either).

So my list is composed by: FY22, FY23, FY24, FY25, FY26, FY27, FY28

The module has the line item "Inventory amount" and "Inventory increase" with the FY list as columns.

The idea is that FY22 is an input, but from FY23 to the end of the FY list it should be a calc doind the inventory amount from last year times the inventory increase on FY23.

How can I do that?

Print as example, FY24 being calculated with amount from FY23 and increase from FY24:

Accepted answers

HimanshuRaj

Hi @PauloM

In that case, you'd need to make a copy of this module with real time,

Pull the increase % value in real time module from fake time module using mapping
Using previous function, calculate the inventory amount in real time module
Pull inventory amount from real time to fake time module using mapping

Cheers!!

All comments

rob_marshall

@PauloM

Instead of using a custom list for the years, why not use a time range or the native Time calendar, with a format of Year? This will allow you to use native time functions like Previous() which would make this much easier to accomplish.

PauloM

I can't use the time because the columns are in fact different versions from forecast, actuals and predicts, so I couldn't really use the built-in time and versions, this is also related to other modules that I have, not only this one, so I can't really use it, I need to keep using the list.

HimanshuRaj

Hi @PauloM

In that case, you'd need to make a copy of this module with real time,

Pull the increase % value in real time module from fake time module using mapping
Using previous function, calculate the inventory amount in real time module
Pull inventory amount from real time to fake time module using mapping

Cheers!!

Quick Links

Can you help?

Unanswered questions

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…
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…