9 Replies Latest reply: Oct 6, 2015 3:26 PM by Manish Kachhia RSS

    Allow filters except the one used in aggregation

      Hello,


      I am trying to accomplish following tasks on my data collection:


      -Filter CreateDate By Today

      -Ignore Any other filter on CreateDate

      -Allow Any other filters to apply

      -SUM(Quantity) for above

       

      Ideally, intersection of following sets;

       

      {$<CreateDate=>} --> Ignores Create Date filter, Yet allows other filters

      {1<CreateDate={"$(=TODAY()"}>} --> Filters CreateDate by Today only

       

      Not getting the results I need. Please advice.