Hi everyone,
I'm trying to create a table using CountIF with the following queries:
PC ACTIVE = CountIf([pc → server] = "N" AND [pc → aktuell] = "Y")
PC INACTIVE = CountIf([pc → server] = "N" AND [pc → aktuell] = "N")
SERVER ACTIVE = CountIf([pc → server] = "Y" AND [pc → aktuell] = "Y")
SERVER INACTIVE = CountIf([pc → server] = "Y" AND [pc → aktuell] = "N")
The query is intended to be integrated into a dashboard with a filter for a customer number.
Unfortunately, the query is returning values that I can't understand:
In the specific case, the query should return the following numbers:
PC ACTIVE = 67
SERVER ACTIVE = 14
Can anyone help?
Thank you very much!