7 Replies Latest reply: Aug 1, 2017 1:46 PM by Josh Akehurst RSS

    Calculate sum if field exists

    Josh Akehurst

      I need to update my load script to perform the following.  I have two fields one which is always assigned to a record (Time) and a second field (compressedTime) which could exist on the record. 

       

      1)  Check if a field exists (compressedTime) on the record and calculate the sum. 

      2)  If the field DOES NOT exist on the record then calculate the sum of another field (Time). 

      3)  Sum of the two fields based on the above criteria.