Summation of column in a form field, (NOT IN A VIEW)

Summation of column in a form field, (NOT IN A VIEW)

Hello all,

I am trying to auto populate the field Total_Hours_Below_Rotary in my Pulser_Reports form from the Service_Hours_Below_Rotary in the form Lifetime_Hours.  The below code is returning the first value entered in the Service_Hours_Below_Rotary column.

What I need to display is the SUM of all entries in the , not just the first entry Service_Hours_Below_Rotary column that match Job_Number, Description,and Serial_Number.

  1. for each value in Lifetime_Hours  [((Job_Number == input.Job_Number && Description == input.Pulser_Size) && Serial_Number == input.Pulser_Serial_Number)]
  2. {
  3.        input.Total_Hours_Below_Rotary = value.Service_Hours_Below_Rotary;
  4. }

Thank you.
Jason Rapp