Skip to Content
Former Member
May 12, 2018 at 01:52 PM

How to model last 10 working days using incremental counter in HANA Graphical Calculation View?

393 Views Last edit May 12, 2018 at 02:23 PM 3 rev

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.