system
June 24, 2004, 1:31pm
#1
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)
system
June 24, 2004, 1:34pm
#2
Please, look in FAQ Reporter first, try this post
Andreas (BOB member since 2002-06-20)
system
June 24, 2004, 1:34pm
#3
You canβt do it this way. The WHERE operator requires an = and a constant.
Do something like this.
Sum(if Order > 0 and Sales > 0 then 1 else 0)
Steve Krandel (BOB member since 2002-06-25)
system
June 24, 2004, 4:43pm
#4
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)