3 Replies Latest reply: Feb 6, 2013 6:02 PM by Rebecca Molstad RSS

    Date selection in set expression not working

      Hello all,


      Am seeing a strange behavior. I want to display the sum of sales just for the Maximum business date, irrespective of selections.


      In the attached file, this expression works as expected and give me the results based on comparison.


      =Sum({$<business_date = {">=$(=Min(business_date)-1)<=$(=Max(business_date))"}>} Sales)



      However, I modified this same expression as below to make it give me sum for just one day (that is the Max of business_date for all the data), it does not work. Always gives me the complete sum.


      =Sum({1<business_date = {"=$(=Max(business_date))"}>} Sales)


      am I again messing up the syntax?


      I have attached the sample files for reference. Please help.