Getting error in set expression and don't know why.

[aschmeelk]

I am using the following code to determine a value:

Count( {<DaysOverDue > {1}>} distinct Work_Order_Number)

where DaysOverDue is a numeric value.

The error is 'error in expression: '}' expected'. I can't see where a brace is missing.

Any help will be greatly appreciated!

[sunny_talwar]

Are you looking for one of these?

Count({<DaysOverDue = {1}>} DISTINCT Work_Order_Number)

or

Count({<DaysOverDue = {">1"}>} DISTINCT Work_Order_Number)

[aschmeelk]

The latter of the two. ok so the > has to be in the braces with the cardinal number and in quotes.  I didn't realize that. Thank you!

[sunny_talwar]

Yup