3 Replies Latest reply: Sep 30, 2014 5:11 PM by Massimo Grossi RSS

    Set Analysis is not working as expected


      Hi All,

       

      Actually i am writing a set analysis to filter the entire data based on a particular date.

       

      Expression used : 
      =

      sum({1<AsOfDate={"=$(=only(date#('2014-09-15','YYYY-MM-DD')))"}>}BookValue_Acct)

       

      Here I am summing up the BookValue_Acct for a particular date 2014-09-15.

      This expression doesnt give the correct result..But if I am making the '=' to  '<=' or '>=' , then its working perfectly fine.

       

      Can anybody please advise me on this ?

       

      2) if I have a list box which contains the dates.. If I want to pass the selected value from list box to this set analysis

      expression , how can i do that ? i tried giving in different ways .but always it gives the syntax error.

       

      Thanks

      Nirmal.