Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can you do an 'or' like in an if statement in set analysis?
Thanks
Hello,
Can you please provide further context to the use case scenario?
As an example here is a set analysis for counting all records with ID = 10: Count({<EmployeeID={10}>}EmployeeID) and here is a set analysis for counting all records where ID equals to 11: Count({<EmployeeID={11}>}EmployeeID). If you would like to count all records where ID is either 10 or 11 then you can use this set analysis: Count({<EmployeeID={10,11}>}EmployeeID).
This is the result that I get:
As you can see, it has properly counted all the records, where the ID is either 10 or 11.
Is this what you were looking for?
Hello,
Can you please provide further context to the use case scenario?
As an example here is a set analysis for counting all records with ID = 10: Count({<EmployeeID={10}>}EmployeeID) and here is a set analysis for counting all records where ID equals to 11: Count({<EmployeeID={11}>}EmployeeID). If you would like to count all records where ID is either 10 or 11 then you can use this set analysis: Count({<EmployeeID={10,11}>}EmployeeID).
This is the result that I get:
As you can see, it has properly counted all the records, where the ID is either 10 or 11.
Is this what you were looking for?