Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 4 fields - data like below (Value1+Value2+Value3=100)
I have to count my records (It should not be greater than 10 for two values)
Below is my table
Name, Value1, Value2, Value2
ABC, 50, 25, 25
BCA ,100,,
ZZZ, 80, 10, 10
AAA, 90, 10,
BBB, 50, 50,
My out put should be (The count should be 3, because here I have no value greater than 10 for all 3 combination values)
Name, Value1, Value2, Value2
BCA ,100,,
ZZZ, 80, 10, 10
AAA, 90, 10
Thanks in Advance!
Try this .
=count({<Value1={">10"}, Value2={">10"}, Value3={">10"}>} DISTINCT Name)