Count Calculate

KNRaju105630 — Wed, 24 May 2023 10:27:51 GMT

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!

Re: Count Calculate

Chanty4u — Wed, 24 May 2023 11:56:22 GMT

Try this .

=count({<Value1={">10"}, Value2={">10"}, Value3={">10"}>} DISTINCT Name)