Where Function

building reports desktopintelligence
1

Hi All,

I’m in process of creating report where i need put couple statements.

Report level is by and in separate columns i need find out how many cities had sales below certain value.

Than i was planning use

=Count() Where (<200)
but DESKI only allow equal operator to be used within below query.
Is there any other way around to get count of cities in each country with sales < > certain value ?

sigterm (BOB member since 2014-03-16)

2 
=Sum(If <Sales> < 200 Then 1 Else 0)

You may need a calculation context also.

Mak 1 :uk: (BOB member since 2005-01-06)