I need to extract the number of Saturday shifts worked per staff member from the attached data (eg Employee number 100077 should generate a result of 6 Saturdays). The field (Shift Start Date) has various dates which I can filter using IsWorkday (which gives a result of 0), or Extract (which gives a result of 7). I assume that I will need to now use Countif to count the number of Saturdays, but keep getting errors. Can someone assist with the correct syntax?
Hi @Aardvark
Welcome to the community!
Please share your calculated field definition and the error message.
Regards,
Giri
Thanks for the response. I have tried countif WeekdayOrWeekend = 0 and countif ExtractWD = 7. Field names with and without { }. Not sure if {Employment number} is also supposed to form part of the equation? - I have tried it with and without to no avail.
Hi @Aardvark
The syntax for countif is as follows
Here’s an example
You can use your employee number for the dimension and your WeekDayOrWeekEnd for the condition part
Regards,
Giri
2 Likes