on 11-09-2016 5:02 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.