Inputting a formula based on range of dates

Contributor

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

Kind regards
Message 1 of 5
4 REPLIES 4
Regular Contributor

Re: Inputting a formula based on range of dates

Can you try something similar to the following,

 

image.png

image.png

 

You can do a calculation if the Boolean is true.

 

Regards

Arun

Message 2 of 5
Highlighted
Contributor

Re: Inputting a formula based on range of dates

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,

Kind regards
Message 3 of 5
Regular Contributor

Re: Inputting a formula based on range of dates

Yes, can be done as well.

 

image.png

 

image.png

Message 4 of 5
Contributor

Re: Inputting a formula based on range of dates

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

Kind regards
Message 5 of 5