topic Calculation for a value to show every 10th of the month in Anaplan Platform https://community.anaplan.com/t5/Anaplan-Platform/Calculation-for-a-value-to-show-every-10th-of-the-month/m-p/106202#M25315

Hi,

 

We need help trying to write a formula for a value to show on only every 10th of a given month. Also need to consider that the weekends do not count and would fall into the next business day. For example 4/10/2021 is Saturday so would pick up 4/12/2021 instead. 

 Sat, 24 Apr 2021 03:21:50 GMT neg177 2021 - 04 - 24 - t03:21:50z Calculation for a value to show every 10th of the month https://community.anaplan.com/t5/Anaplan-Platform/Calculation-for-a-value-to-show-every-10th-of-the-month/m-p/106202#M25315

Hi,

 

We need help trying to write a formula for a value to show on only every 10th of a given month. Also need to consider that the weekends do not count and would fall into the next business day. For example 4/10/2021 is Saturday so would pick up 4/12/2021 instead. 

 Sat, 24 Apr 2021 03:21:50 GMT https://community.anaplan.com/t5/Anaplan-Platform/Calculation-for-a-value-to-show-every-10th-of-the-month/m-p/106202#M25315 neg177 2021 - 04 - 24 - t03:21:50z 再保险:计算for a value to show every 10th of the month https://community.anaplan.com/t5/Anaplan-Platform/Calculation-for-a-value-to-show-every-10th-of-the-month/m-p/106214#M25321

Hi  

 

I have created a solution with simple test module which will give the 10th day of the month and if 10th is a weekend then it gives the next business day of the month.

TonyViGrand_0-1619264291513.png

TonyViGrand_1-1619264337605.png

TonyViGrand_2-1619264520593.png

 

In case if you are looking for a solution which gives the 10th working day or business day of every month excluding all weekends then the below snip will help you.

TonyViGrand_3-1619264599032.png

 

Hope one of the above solutions will help you.

 

Regards,

Tony Grand

 

 Sat, 24 Apr 2021 11:45:56 GMT https://community.anaplan.com/t5/Anaplan-Platform/Calculation-for-a-value-to-show-every-10th-of-the-month/m-p/106214#M25321 TonyViGrand 2021-04-24T11:45:56Z