Skip to Content
avatar image
Former Member

Getting a specific count on values in web intelligence

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 09, 2016 at 06:25 PM

    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

    Add comment
    10|10000 characters needed characters exceeded