3 Replies Latest reply: Jul 22, 2013 11:56 AM by Celambarasan Adhimulam RSS

    Basic set analysis question

      Hi Experts,

       

      I have a very simple set analysis question.

       

      In the ordr table we have a filed  which stores the year value of the order ex. 2010, 2011, 2012, 2013 and so forth.

       

      I am trying to get my set exprerssion dynamic and running into the following ptoblem

       

      Original expression

      sum({$<ORD_YR ={'2013'} >} AMT)   --> Works great

       

      New one

      sum({$<ORD_YR ={"= $(=num(year(Today(0))))"} >} AMT)   ---> Doesn't consider the set expression results are same as sum(AMT)

       

       

      An alternate that works

      sum({$<ORD_YR ={">= $(=num(year(Today(0))))"} >} AMT)    --> please note the >= comparison

       

       

      So how do I use set expression for limiting the total to based on the current year value?

       

      Thanks,

      AP.