Error Message with Formula

abbysg
abbysg
in Modeling

Update the formulas to reference the driver data in the EMP03 Employee Driver by Role module. 

 

 

Formula I am using: 

 

IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0

 

 

Error message after using the formula: 

IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0

Tagged:

Answers

  • cbrookes
    cbrookes

    Looks like you pasted the formula twice instead of including the error message. Would also be helpful to include dimensions of target module.

Categories