Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to count distinct value base on 2 Fields. Below is example,
Id's & Defect Code can be duplicate as per data, but I just need Unique count for ID & Defect Code.
like = Count(Distinct(ID) , Distinct(Defect Code))
Result = 5 ( Highlighted Yellow for example)
ID | Defect Code |
1 | 11119 |
2 | 11113 |
2 | 11117 |
3 | - |
4 | - |
4 | 11118 |
5 | - |
5 | 11122 |
5 | 11114 |
6 | - |
7 | 11123 |
8 | - |
hi
Maybe this
If([Defect Code]<>'-',count(distinct(ID)))
Thanks Pratyush,
But is not working 😞
May be this
Count(DISTINCT {<ID = {"=Count([Defect Code]) > 0"}>} ID)
or
Count(DISTINCT {<[Defect Code] = {'*'}>} ID)
Thanks Sunny,
Count(DISTINCT {<[Defect Code] = {'*'}>} ID)
This works perfect.
Appreciate if you can explain this formula to me. DISTINCT {<[Defect Code] = {'*'}>}
The expression is just distinct counting IDs where Defect Code is not null ({<[Defect Code] = {'*'}>})
Great Thanks for you help.
No problem at all