Use the following formula to add the values in two columns from the external data—Reg Hours and Other Hours—to determine employees' regular hours. The application converts all data to strings, so note that the GETDECIMALVALUE function is used to retrieve a numeric value.
Import Type: Employee Time Card
Column: Regular Hours
Calculation: Formulas.GetDecimalValue(pData(“Reg Hours"))+Formulas.GetDecimalValue(pData(“Other Hours"))