Count where Value > x

building reports desktopintelligence
1

I have a table like this:

OID Payload
1 213
2 199
3 132
4 212

I want to create a variable that counts the number of payloads above 200.

The OID is unique but what is the syntax?

count() where > 200

Does not work

fghs_1987 :uk: (BOB member since 2008-01-02)

2

HI,

It is not the right use of Where operator.
This is the right form of using where:
measure Where (dimension = (number or character string or date, dimension = …))
Try this function to claculate the number of occurence of OID where
where > 200 .

Create a new cell in the buttom of the table and put this code :
=Sum(((If (>200) Then 1 Else 0)))

Bobj_helper (BOB member since 2010-05-10)