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

    Allow filters except the one used in aggregation


      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.