2 Replies Latest reply: Aug 26, 2011 11:27 AM by Sunil Chauhan RSS

    Using a less than (<) modifier in set analysis

      Hi all,

       

      I have a data set that contains dates (INSTDATE) and values (LENGTH).

       

      I want to use set analysis to sum all values less than the date given. The date given will be an input variable which the user enters. Lets say for this example that the date is 01/01/2010.

       

      My attempts at set analysis expressions:

       

      Sum ( {< INSTDATE < {'01/01/2010'} >} LENGTH)   ---> doesnt work, can't seem to use < symbol as a modifier

       

      Sum ( {< INSTDATE = $(<'01/01/2010') >} LENGTH)  ---> doesn't work

       

       

      Can anyone tell me how to use a less than operator in set analysis please?

       

       

      Thanks

      Dan