Simple Count/Where/Or statement

building reports webintelligence
1

Hi All,

I know this is going to be simple but I cant seem to work out how to correct this Count/Where/Or statement. My formula is below and I have the data in front of me to validate. The results should be 2 but instead I am getting 4, as if its using the Or as an AND.

=Count([ID]
Where
(
([Op1] <> "Request" Or [Op1] <> "Bug")
)
)

Table:

ID Op1
1 Request
2 Request
3 Inc
4 Req

Can anyone please confirm the correct syntax?

Thanks

ianwillo (BOB member since 2012-08-03)

2

If Op1 does not equal Request then it can equal Bug

Use And instead of Or

3

Hi,
you should use AND instead of OR.
Cheers,
Rogerio

rgoulart :brazil: (BOB member since 2011-08-21)

4

Thanks for the replies both.

The And instead of Or works great!

I knew it would be simple!!!

Thanks

ianwillo (BOB member since 2012-08-03)