If statement

[#1]

Hi,

can you help - I want to count the number of sessions that are classed as waiting list initiatives, but split them for week and weekend. I have a day if week variable and the session type variable is where you will find waiting list initiative amongst others. At the moment it is just counting all of the session types.

So I need - if the day of the week is sat or sun and the session type is waitinglist initiatives then count how many there are...

=if(day_of_week, 'Saturday' or 'Sunday' and session_type = 'Waiting List Initiative',

count (session_type))

Thanks,

[Gysbert_Wassenaar · Accepted solution]

If you have fields named day_of_week and session_type you can try this:

count({<day_of_week={'Saturday','Sunday'},session_type={'Wailting List Initiative'}>} session_type)

[#3]

count({<day_of_week={'Saturday','Sunday'},session_type={'Wailting List Initiative'}>} session_type)

[#4]

Thank you very much