3 Replies Latest reply on Dec 7, 2018 12:22 PM by Vinnie Ahuja

    Summing 2 fields based on different date fields.

    Bob Zdon

      I am trying to sum a field that is the number of products shipped (based on the date shipped) with a field that is the number of products returned (based on the received date) to determine number of actions taken. 

       

      [quantityshipped] + [quantityreturned]

       

      The date fields are [dateshipped] and [datereturned] respectively.

       

      So I have 2 different date fields that are driving each summed field.  I also need to have a filter so the user can select the month they want to look at so the filter would have to apply to both date fields.  I cannot figure out how to do this.  Any advice?