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

    Set Analysis is not working as expected

    Nirmal Vengapetta

      Hi All,


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


      Expression used : 



      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.