Data in database table:
| PERSON | SALARY | COUNTRY |
|---|
| Person1 | 0 | Greenland |
| Person2 | 200 | Greenland |
| Person3 | 200 | Italy |
| Person4 | 200 | Italy |
| Person5 | 200 | Italy |
| Person6 | 200 | Italy |
| Person7 | 200 | Italy |
In OBIEE analytics, I want Analysis like below:
| Amount of persons count(person) |
|---|
| Total persons who get salary | 6 |
FILTERS:
Salary is bigger than 0 (salary > 0)
------------------------------------------------------------------------------------------------------------------------------------------------------------
The problem is that filter does not working and it counting every line, including zero value, like below.
TOTAL PERSONS WHO GET SALARY : 7 (thats a wrong answer, it should be 6)
- This is raw example, I have about 10 000 persons and about 500 persons who not get salary/zero salary, I can't put all those persons in the report, I need only total sum of persons.
- If I try use column formula like: filter(count(person) using salary > 0), it gives error message. There's no allowed grouping or something like that: Aggregate is not allowed within USING clause of a FILTER operator nQSError: 22034
- Also I put measurements in RDP, using case function but result is same in report: 7
Does anyone have any idea how I should resolve this situation?