Lock Lookup. Possible?

Atz1234 · 2024-11-02T12:27:36+00:00

There was an error rendering this rich post.

Hi everyone is there any possibility to lock the lookup function when using offset? what i want to achieve is when i change my time period, the awarded will take the current period in module Construction Forecast-Awarded and will be place in Awarded column. same thing in Awarded 2nd Month, it will display the second month. so i tried the OFFSET function but unfortunately the dimension month will move also to the next month.

i have a module which my dimension is time

on my Awarded Column, this is my formula:

and on my Awarded 2nd month, this is my formula:

Accepted answers

All comments

AjayM

If I am not wrong, you want model's current period setting to be locked as current month for 'Awarded', and corresponding 2nd month as the subsequent month.
If you always want 'current period' value to be fetched into 'Awarded' lineitem, why do you need time dimension to that lineitem? Same applies to 'Awarded 2nd Month' lineitem.

seymatas1

Hi @Arth,

The question isn’t clear to me. Can you make it a bit more understandable? For example, you can create a line item called "Expected Result" and type the number you expect to see in the cell.

Also, instead of using OFFSET, you can create another line item called "Previous Month to Lookup" and use LOOKUP on that line item. OFFSET is calculation-heavy, so it's better to avoid it if possible.

If you need to offset only by one month, consider using the PREVIOUS() or NEXT() functions instead.

I also noticed that your "Date to Lookup" and "Month to Lookup" line items both have "month", once you finish your development, you should delete one to keep things simple.

Lastly, try to put your lookup line items in a smaller system module for better model performance.

I hope this helps!
Şeyma 🌷🙂

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…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
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…