AnsweredAssumed Answered

Month Calculation Help

Question asked by mgxdigital on Jun 11, 2010
Latest reply on Jun 11, 2010 by fitch

Title

Month Calculation Help

Post

Help with calculation would be amazing! Thanks in advance.

 

3 fields:

Orders:ShipDate

Calendar: DateDisplay

Orders:TotalShipped

 

Calendar: DateDisplay is of course, on a calendar layout. You can switch from month to month. This is from the SeedCode Calendar.

 

I'm wanting a calulation to show  the total of orders:totalshipped for only the orders shown on the month (calendar:displaydate) shown.

 

Currently, it will add all of the orders:total shipped for the entire month shown (even when the days at the beginning and end of the month are in the past/future month)

 

So, if the month of the orders:shipdate is the same as the month of the calendar:display date then add the orders:total shipped of only the days in that month.

 

 

Thanks for the help!!!

Outcomes