Example 6) Evaluating Data
Suppose you want to evaluate values in two columns from the external data—NewHire and EmploymentType—to determine the pay status change reason in the application as follows:
|
New Hire Value in External Data |
Employment Type Value in External Data |
Pay Status Change Reason Value in Viewpoint Estimating |
|---|---|---|
Y |
P |
NEWHIRE |
Y |
T |
TEMP |
N |
T |
TEMP |
N |
P |
PERM |
[another value] |
[another value] |
[blank] |
Use the following formula to do this.
Import Type: Employee Time Card
Column: Pay Class
Calculation: IIF((pdata(“NewHire”)=”Y” AND
pdata(“EmploymentType”)=”P”), pdata(“PayStatusChangeReason”)=”NEWHIRE”,
IIF((pdata(“NewHire”)=”Y” AND pdata(“EmploymentType”)=”T”),
pdata(“PayStatusChangeReason”)=”TEMP”, IIF((pdata(“NewHire”)=”N” AND
pdata(“EmploymentType”)=”T”), pdata(“PayStatusChangeReason”)=”TEMP”,
IIF((pdata(“NewHire”)=”N” AND pdata(“EmploymentType”)=”P”),
pdata(“PayStatusChangeReason”)=”PERM”,””))))
