Inputting a formula based on range of dates

Hi All,

I'm fairly new to Anaplan and have a module that gets start period and end period. What I want to do is use these time range in order to set a specific amount based on a formula.

I want to apply a specific formula on the time periods with respect to the start period and end period. To give an example, in one cost center, the start and end period is Jan 19 to Jun 19 respectively. I want to compute for the allowance for this specific range. Any help would be greatly appreciated.

Thanks in advance!

Jad Daffon

Accepted answers

ArunManickam

Yes, can be done as well.

All comments

ArunManickam

Can you try something similar to the following,

You can do a calculation if the Boolean is true.

Regards

Arun

CommunityMember88511

Hi Sir @ArunManickam,

The time period that i'll use as reference is formatted as time period (months). Is there a way to this months similar to the date format that you have provided?

Kind regards,

ArunManickam

Yes, can be done as well.

CommunityMember88511

HI @ArunManickam

Sorry for the late revert. This worked perfectly. Already applied it to our model for allowance computation. Thank you very much for your help!

Kind regards,

Jad Daffon

NehaSharma

Hi,

I tried to apply the same logic. However for me the start and end date is coming from a different module.Both the line items are date formatted. I am getting below mentioned error. Just for your information I am creating a Boolean line item to clear data which falls under this specific time range. In this boolean line item I am trying to write the formula.

Can you please help me on this.

Thanks in advance.

CommunityMember126793

@NehaSharma change the data type to "Time Period" "Month"

NehaSharma

Thank you!

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385