3 Replies Latest reply: Apr 5, 2018 3:50 PM by Sunny Talwar

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

Alan Schmeelk Apr 5, 2018 2:49 PM

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!

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

Sunny Talwar Apr 5, 2018 2:57 PM (in response to Alan Schmeelk)

Are you looking for one of these?

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

or

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

Actions
- Re: Getting error in set expression and don't know why.
  
  Alan Schmeelk Apr 5, 2018 3:47 PM (in response to Sunny Talwar )
  
  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!
  
  Like Show 1 Like (1)
  
  Actions
  - Re: Getting error in set expression and don't know why.
    
    Sunny Talwar Apr 5, 2018 3:50 PM (in response to Alan Schmeelk)
    
    Yup
    
    Like Show 0 Likes (0)
    
    Actions