I need to do a count where a measure is greater than a certain value. This is the syntax I am trying to use:
=count(<IDs>) where (Order > 0 and Sales > 0)IDs is a dimension, Order and Sales are measures. I keep getting a syntax error.
Any suggestions?
khansen97 (BOB member since 2003-12-05)
You can’t do it this way. The WHERE operator requires an = and a constant.
Do something like this.
(BOB member since 2002-06-20)Sum(if Order > 0 and Sales > 0 then 1 else 0)Steve Krandel 
(BOB member since 2002-06-25)
Just to be clear if someone gets this thread in a search – the WHERE mentioned above is the clause in a Report variable, not the WHERE clause in SQL.
Anita Craig (BOB member since 2002-06-17)