6 Replies Latest reply: Apr 30, 2015 4:04 PM by Sunny Talwar RSS

    Set Analysis - Numeric Range

      I cannot see the error in my syntax.  Can anyone else?

      This works and gives me the sum of 'GL_Value' for 'GL_Account_Number's greater than or equal to 9000:

      sum({$<GL_Account_Number ={">=9000 " }>} GL_Value )

       

      This works and gives me the sum of 'GL_Value' for 'GL_Account_Number's less than 9200:

      sum({$<GL_Account_Number ={"<9200 " }>} GL_Value )

       

      BUT this does not work.  It gives me ALL the GL_Account_Numbers, not just 9000 to 9199.

      sum({$<GL_Account_Number ={">=9000 <9200" }>} GL_Value )


      I want the intersection set, not the union. All the documentation I find has this as the correct syntax but it is not working for me.