Skip to Content
0

Getting a specific count on values in web intelligence

Nov 09, 2016 at 05:02 PM

45

avatar image

compliance.png

Hi,

I need to get a count where if all of the values are same then 0 if one is different then 1.

currently I have =Count([Compliance Bullet 1]) which is counting everything but I need to only display what is different. If you look at the snap shot you can see that for compliance 1 there is one change so it should count as 1 and compliance 2 I see no change so I should see 0.

Let me know if you need more clarification.

Thanks,

Ahmad.

compliance.png (9.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Nov 09, 2016 at 06:25 PM
0

Hi,

Does Compliance always have Yes or NO flags?. Do you want count of "No" if complaince1 has No more than 1 or just a flag 1 and 0?.

Try this to display number of "No"'s

=If ([Compliance Bullet 1] = "No") then Count([Compliance Bullet 1]) else Count([Compliance Bullet 1])

You need to write the same formula for Compliance 2 and so on.

If you want to display just 1 if it is No then try this:

=If ([Compliance Bullet 1] = "No") then 1 else 0

write same for remaining Compliance's.

Thanks,

Jothi

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks, but that's not what I was looking for.

0