Forum Discussion

vijay273162's avatar
vijay273162
Helper III
4 years ago
Solved

Calendar Table help

Hi All, Attached my Calendar Table for help on creating 1 Calulcated column.   https://drive.google.com/file/d/1I9cTfS9Dta6U2SrqBxCbT8Xk7OGGAStH/view?usp=sharing   Below is the snapshot of What ...
Need Help
Show and Tell
Tips and Tricks
  • vijay273162's avatar
    vijay273162
    4 years ago

    Here is the solution. Hpe it helps others !!

     Create a calculated table (only taking the current Quarter Date ) in it.

    Use LOOKUPVALUE syntax, to bring the date into Business Day no. irrespective of Year.

     

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi vijay273162 

To make it quicker for everyone to help you, could you please fill in each row in the picture with the expected result? Are the expected results based on Running Day - Excluding Wknd.?

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.