Error validating the formula for column attendance

Ramco Ramco

3y764SQL

When i write the below code in Formula i get above error

CASE
    WHEN (
        SELECT COUNT(*)
        FROM [SessionDeliveryParticipant] AS sub
        WHERE sub.SessionDeliveryCalendarID = [SessionDeliveryParticipant].SessionDeliveryCalendarID
        AND sub.PresentInSession = 0
    ) = (
        SELECT COUNT(*)
        FROM [SessionDeliveryParticipant] AS sub2
        WHERE sub2.SessionDeliveryCalendarID = [SessionDeliveryParticipant].SessionDeliveryCalendarID
    ) THEN 1
    ELSE 0

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

cjard3y ago
When asking for help you should always say exactly what error message youre getting

I think I'd do that as an "when exists(select ... where presentinsession <> 0) then 0 else 1" instead of counting all items and counting all zeroes to make sure they are all zero; "not exists any non-zero" is the same as "all items are zero"