Correct syntax for Countif calculation


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