Formula to end time

Hi I have this formula that will add 1(digit) to the months following the current start month however I would like it to stop adding number after month 23. I can't figure out how to end the argument/formula so it stops adding number.

Ex: Current month is 0, Next month is 1, following month is 2 etc, last month should be 23. How do I get it to stop counting after 23

IF ITEM(Time) = 'SYS02 Filter - Input'.'Start Month (F. Export)' THEN 0 ELSE IF ITEM(Time) > 'SYS02 Filter - Input'.'Start Month (Synergi Export)' THEN PREVIOUS(Step) + 1 ELSE 0

Accepted answers

All comments

Akhtar.shahbaz

Hi @umandiwa ,

There is a different way to calculate to stop the period, as of now i can think of below approach

You can use last period as your filter also.

Hope this will help

Thanks

Akhtar

ankit_cheeni

Hi @umandiwa

If I were new to Anaplan, I would have created something like this:

IF ITEM(Time) = 'SYS02 Filter - Input'.'Start Month (F. Export)' THEN 0 ELSE IF ITEM(Time) > 'SYS02 Filter - Input'.'Start Month (Synergi Export)' THEN IF PREVIOUS(Step) <= 22 THEN PREVIOUS(Step) + 1 ELSE 0 ELSE 0

To make it slightly better, I would have a separate system module without any dimension that will take the number 22 as a user input in consonance with PLANS and then refer that instead of hard coding the number 22.

Not sure if you can, but try to limit the number of IF/THEN/ELSE loops that you have

Let me know if that helps

Akhtar.shahbaz

Added as a filter

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…