Hello Riyaz, I am not seeing the second subject area, I guess it only shows if the organisation is using some kind of time recording system…

This is now solved, the last piece of the jigsaw was that the TIMESTAMPDIFF part was returning as an integer, this was rectified by casting as a decimal and the issue was resolved Weeks Between Working Dates CAST((TIMESTAMPDIFF (SQL_TSI_DAY, {CASE WHEN CAST(@{F_Date}{'YYYY-MM-DD'} AS DATE) > "Assignment Event…

Thanks All, I am nearly there now with all your help. I have a further issue - I deed to calculate the number of decimal weeks between The Working Start Date and the Working End Date. I am using the TIMESTAMPDIFF function (Days then result divided by 7) for this using the two calculated Working Date columns, However, if I…

Thanks all for your help so far, I have found the appropriate subject area and begun my analytic. I have now hit an issue; Each line in the analytic (catalog attached) is an assignment event with a start date and an end date, however, I wish to report on specific date periods provided by the presentation Variables obtained…