Counting Confirmed Guests
Hoping for some assistance.
Trying a work a formulae that sums the total amount of guests that have "Check In" to an event.
My current formulae is
Checked In = 1 (Yes)
sum(Guests['Checked In' = 1].'Total Pax') + cnt(Guests['Checked In' = 1].'Checked In')
It does seem to work, but it keeps adding an extra person. i.e i have 5 guests in one group who have "Checked In" and the number is coming back as 6.
Ive tried adding "- 1" at the end of the formulae but this will only work for one group and not if i have multiple groups.