Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to Count values in one column but only if the value appears once. As well as values which appear more then once and how many duplicates.
9002216 |
9002217 |
9002218 |
9002218 |
9002218 |
9002219 |
e.g.
values appearing once: 3
values appearing more than once: 1
duplicates appearing: 3
Thanks for helping
Value appearing one
Count(DISTINCT{<Value = {"=Count(Value) = 1"}>}Value)
Value appearing more than once
Count(DISTINCT {<Value = {"=Count(Value) > 1"}>}Value)
Duplicate appearing
Count({<Value = {"=Count(Value) > 1"}>}Value)
Value appearing one
Count(DISTINCT{<Value = {"=Count(Value) = 1"}>}Value)
Value appearing more than once
Count(DISTINCT {<Value = {"=Count(Value) > 1"}>}Value)
Duplicate appearing
Count({<Value = {"=Count(Value) > 1"}>}Value)
Hello Sunny,
thank you very much.
Would anyone be so kind and help me with the following :
sum full pallets if value appearing more than once
sumd full pallets if value appearing only once
Thank you very much for your help
May be this
sumd full pallets if value appearing only once
Sum({<Value = {"=Count(Value) = 1"}>} [full pallets])
sum full pallets if value appearing more than once
Sum({<Value = {"=Count(Value) > 1"}>} [full pallets])
Thank you. Worked perfectly