-
1. Re: Duplicate values
Akram Ebrahim Sep 10, 2019 5:16 AM (in response to Abdul A)Hi Abdul
Try the calculation
{ Fixed [Company]: SUM(IIF([Purchased]="Y",1,0))}
-
2. Re: Duplicate values
Zhouyi ZhangSep 10, 2019 5:20 AM (in response to Abdul A)
Hi, Abdul
Try this
{ Fixed [Company]: AVG(IIF([Purchased]="Y",1,0))}
ZZ
-
3. Re: Duplicate values
Ashfaque Shaikh Sep 10, 2019 5:20 AM (in response to Abdul A)Hi Abdul,
Check with below formula
Hopefully it help you.
SUM(IF {FIXED [Company] : COUNTD([Purchased])=1} then 1 else 0 end)
Thanks,
Ashfaque
-
4. Re: Duplicate values
Chris McClellanSep 10, 2019 5:21 AM (in response to Abdul A)
1 of 1 people found this helpfulI think you're after SUM not COUNT ..... COUNT will be 2 (as in 1 and 0) but SUM will be 1 ( 1 + 0 )
-
5. Re: Duplicate values
Abdul A Sep 10, 2019 6:10 AM (in response to Ashfaque Shaikh)It is not working for me
-
6. Re: Duplicate values
Abdul A Sep 10, 2019 6:11 AM (in response to Zhouyi Zhang)It throws error Integer cant compare with String
-
7. Re: Duplicate values
Abdul A Sep 10, 2019 6:11 AM (in response to Chris McClellan)yes, I am looking for count not sum
-
8. Re: Duplicate values
Zhouyi ZhangSep 10, 2019 6:13 AM (in response to Abdul A)
you [Purchased] is a integer?
ZZ
-
9. Re: Duplicate values
Abdul A Sep 10, 2019 6:14 AM (in response to Zhouyi Zhang)no, but AVG(IIF([Purchased]="Y" those error, because it is looking for integer
-
-
-
12. Re: Duplicate values
Chris McClellanSep 10, 2019 1:38 PM (in response to Ashfaque Shaikh)
1 of 1 people found this helpfulGiven the example data above, there is no need to use an LOD here. Wouldn't this work the same way ?
SUM(IF COUNTD([Purchased])=1 then 1 else 0 end)
-
13. Re: Duplicate values
Ashfaque Shaikh Sep 11, 2019 1:05 AM (in response to Abdul A)Hi Abdul,
Its Humble request please mark any of the answers which was helpful to you.
And please close thread.
Thanks,
Ashfaque
-
14. Re: Duplicate values
Abdul A Sep 11, 2019 6:21 AM (in response to Ashfaque Shaikh)Hi, I will try this and post here if any issues or else will mark as asnwer