AnsweredAssumed Answered

Get Summary based on 2 criterias

Question asked by PatrickHolzer on Feb 16, 2009
Latest reply on Feb 17, 2009 by PatrickHolzer

Title

Get Summary based on 2 criterias

Post

Hi,

 

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):

Get(CurrentDate)-30

 

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.

 

Thanks!

- Patrick

Outcomes