I have a query on how I would calculate the number of consecutive absense in a period. e.g. see data below
If someone has more than 7 absense in a row in a period I need to highlight this. I have tried before() but it only works if I run the report for one person
expression of "=Date-before(date)" and make a selection on the pay-code which tells me someone was working that day.
If i run it for all people and the person was absent on a particular day - the column to the left is NULL and so the before() function does not work.
if someone is in work they will have a record with a particular pay code for that day. An absense may be a holiday, where there will be a record for that day under a different pay code or a weekend or rest day where there will be no record for that day
Any help or pointers in the right direction would be greatly appreciated.
