7 Replies Latest reply: Oct 29, 2015 12:18 AM by Prashant Sangle RSS

    Problem using greater than or equal in set analysis

    John Irwin

      I've searched and read suggestions but nothing has worked yet.

       

      I'm using 11.20 SR 7 on Windows 8.1

       

      I'm trying to use set analysis in an expression in a straight table.

       

      This works:

      SUM({$<APPLICATION_TERM_CNENR={"2015B","2015C","2016A"}>} DEPOSIT_AMT_PAID_CNENR)

       

      I wanted to do something like:

      SUM({$<APPLICATION_TERM_CNENR>={"2015B"}>} DEPOSIT_AMT_PAID_CNENR)

       

      It makes sense it wouldn't work because the > would be interpreted as the end of the search condition not as greater than.

       

      Things like the following don't work (trying single and double quotes)

      SUM({$<APPLICATION_TERM_CNENR={'>="2015B"'}>} DEPOSIT_AMT_PAID_CNENR)

      or SUM({$<APPLICATION_TERM_CNENR={">='2015B'"}>} DEPOSIT_AMT_PAID_CNENR)

       

      I was surprised that the following didn't work, it seemed like there were examples nearly like that.

      SUM({$<left(APPLICATION_TERM_CNENR,4)={">=2015"}>} DEPOSIT_AMT_PAID_CNENR)

       

      It needs to see >= as a comparison and then 2015B as a text string.

       

      What do I misunderstand here?

       

      John