Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon all,
Could someone please advise how I can have multiple criteria in one command which is for a traffic light system (Zero = Red, 1 = Green) so the following should display red/green depending if the hours have increased/decreased. I can make it work if there is only 1 criteria for Leavename but I need to add in two more (underlined)
IF(SUM({<Leavename={'Statutory Sick Pay'},Leavename={'Company Sick Pay',Leavename = {'TUPE Sick Pay'},Week_Class ={'Current Week'}>}holidayhours)
-(SUM({<Leavename={'Statutory Sick Pay'} ,Leavename={'Company Sick Pay'},Leavename = {'TUPE Sick Pay'},Week_Class ={'Week-1'}>}holidayhours))>0,0,1)
So total holiday hours where week class = current week AND (Leavename = Statutory Sick Pay OR Leavename = Company Sick Pay OR Leavename = TUPE Sick Pay). I have tried adjusting syntax and Googling to no avail.
Much appreciated,
Matt
I am not a set analysis expert, but I think you need to change the syntax for Levename as follows:
Leavename={'Statutory Sick Pay', 'Company Sick Pay', 'TUPE Sick Pay'}
I am not a set analysis expert, but I think you need to change the syntax for Levename as follows:
Leavename={'Statutory Sick Pay', 'Company Sick Pay', 'TUPE Sick Pay'}