cancel
Showing results for 
Search instead for 
Did you mean: 

Getting a specific count on values in web intelligence

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

jyothirmayee_s
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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