14 Replies Latest reply: Feb 27, 2014 11:09 AM by Ella Miller RSS

    set analysis: sum of amount when date in range not working

      Hi Guys,

      I'm trying to use set analysis and get the sum of a field called "count_recommendations" when its date is in range.

      I'm using the following:

      sum({<DateOnly= {'<=$(=vYesterday) >=$(=v3days)'}> } count_recommendation)

      but the results show only 0.

       

      vYesterday and v3days are variables that are set to recieve yesterday and 3 days ago dates respectively.

       

       

      Am I using the wrong syntax? because an other question here with that topic was resolved with that answer....

      can you help?