2 Replies Latest reply on Feb 17, 2009 7:34 AM by PatrickHolzer

    Get Summary based on 2 criterias



      Get Summary based on 2 criterias




      I've got a field called "orders_shipped_total" where I summarize the quantity of all orders if their status is "shipped"; it looks like this:


      Case(Order_Status="shipped" ; Order_Quantity ; "")

      ... from there, I have a Summary-Field that totals the "Order_Quantity"


      So far so good...


      Now, I want to know the total only for the last 30 days.


      So, I created a field called "Date_Minus30" which looks like this (and works fine):



      The problem is:


      I want to have something like this (in words):


      Sum up all orders if:

      A) their status is "shipped"

      B) the order date is more recent than "Date_Minus30"


      I just don't know how to combine two criterias into one Summary Field.



      - Patrick