Hello.
I want to calculate difference between dates. The running-different function would be OK, but this use every day. I need just working days. (The working days can be found in WORKPERIOD table)
The running-different function do this:
running-difference ( julian_day( [DATE] ) for [ID])
ID Date Difference Difference I need
1234 2018-10-24 0 0
1234 2018-10-25 1 1
1234 2018-10-29 4 2 , because 10-27, 10-28 is non-working day
1234 2018-10-31 2 2
Could someone help me how ,,filtered non-working day" in calculation?
Thank you.
(Cognos 10.2 Report Studio)
How are these working days stored in this table? Maybe you can do a count of some sort where the working days are in a date range. When a working day is represented with a flag or Boolean column, maybe you can count those.
You can use _day_of_week(Date,1) not in (6,7) in filter and then do diffence calculation