1 Reply Latest reply: May 15, 2014 10:15 AM by Olly Bond RSS

    Operand Types - error

    psrs0810 _

      I am trying to apply a filter on my data - The same filter that I have used for the past few years and now I am getting an Operand Type error and the filter will not apply.


      Why would this happen?


      I even rebuilt the filter and I am still getting the same error.


      Thank you

        • Operand Types - error
          Olly Bond

          Hello psrs,


          Can you copy and paste the filter expression into the thread? My guess is there's a trailing bracket or full stop that's off, or that your regional settings aren't happy.


          Monarch, what with Datawatch being a US company, defaults to using commas as logical separators in If(expression,truevalue,falsevalue) formulae and such.


          If your regional settings assume that the comma is a decimal character, this can give nonsense, which is why it's safer to use If(expression;truevalue;falsevalue).


          Another Monarch quirk is .or. and .and. and .not. - do these date from the days of dBase III? - are you sure the "."s are all present and correct?


          Best wishes,