Suppose you want to replace values in the pay class column from the external data to values appropriate for Viewpoint Estimating as follows:
Value in External Data |
Value in Viewpoint Estimating |
|---|---|
vac |
vacation |
hol |
holiday |
sck |
sick |
[another value] |
[the default pay class for the employee] |
Use the following formula to do this.
Import Type: Employee Time Card
Column: Pay Class
Calculation: IIF(pdata("pay class")="vac","vacation",IIF(pdata("pay class")="hol","holiday",IIF(pdata("pay class")="sck","sick",pData.Employee.Time_Card_Default_Pay_Class)))