Hi All,
One of my requirement requires me to get a list of days for last 10 working days(working days calendar been provided by Business),
My Approach: The way I was trying to achieve by creating an incremental counter starting from the current day but I am unable to model it in the graphical calculation view, any suggestion is welcome, below screenshot to explain the logic.
Note: If it is not possible to achieve the same in Graphical calculation view, can someone help me with the code for creating the same in SQL scripted view?
Thanks in advance for any suggestion.
Regards,
Abhi