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
Hi @Aardvark,
It’s been awhile since we last heard from you on this thread, did you have any additional questions or did the suggestion provided above help with your case?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!