Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is a correct formula with a countdiscount on field Headcount and the conditions are a list of codes.
So count(discount(Headcount) if departmentcode <> 1234 or departmentcode <> 2234 etc
Thanks
What is a count discount? Sorry, I don't understand. Do you want to do a DISTINCT count?
=COUNT( DISTINCT IF(departmentcode <> 1234 or departmentcode <> 2234, Headcount))
Discount is Distinct right?
Count({<departmentcode-={1234, 2234}>}Distinct Headcount)
thanks ! sorry for the typo !