Post transaction after 2 working days

Options
LancyRebello
LancyRebello Member, ALL USERS, Certified Model Builder Posts: 3 New Contributor
in Planning & Modeling

Hi Community,

 

I need a help to post transaction after 2 working days. 

 

I have a daily collection amount as a line item in a input module. I want to post these daily collection amount in a calculation module after two working days. For e.g. Monday, 1 March 2021 collection amount will be posted on Wednesday, 3 March 2021 and Thursday, 4 March 2021 collection amount will be posted in Monday, 8 March 2021. Weekends and Bank holidays will be considered as a non working days. 

 

I already have a Boolean formatted System Module showing all the working days (excluding weekends and bank holidays). 

 

Any suggestions? 

 

Regards,

Lancy

Tagged:

Comments

  • LancyRebello
    LancyRebello Member, ALL USERS, Certified Model Builder Posts: 3 New Contributor

    Thanks for the suggestion but this logic will post Thursday and Fridays values in Monday. In every week without any holiday Thursday value should be posted on Monday and Friday value should be posted on Tuesday. 

     

    If there is a holiday e.g. Monday is Holiday then Thursday value should be posted on Tuesday and Friday value should be posted on Wednesday. 

     

     

  • LancyRebello
    LancyRebello Member, ALL USERS, Certified Model Builder Posts: 3 New Contributor

    @LipChean_Soh 

     

    Awesome. Thanks you for both suggestions.

     

    I prefer the first option of creating a fake list and adding that list as a dimension in the line item and reporting Min number. It is easier for a user to increase or reduce list members based on continuous holiday period rather than try to amend formula. 

Categories