Level1: EMP03 Employee Drivers by Role does not return any data

kmanku

 

Hi Experts,

 

Below formula does not return any data, i tried many different types but it does not work. but the EMP01 employee driver returns the data.

'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role, LOOKUP: 'SYS08 Employee Details'.Department]

 

Regards,

Kiran.

 

 

kmanku

 

Hi,

 

Thanks for the response, this is happening when calculating the Bonus in "EMP02 Employee Expenses" , Bonus % is available in "EMP03 Employee Driver by Role" when i write a formula to get the bonus % it is not pulling any data from the "EMP03 Employee Driver by Role".

i did not get any error in the formula, but it did not get any data back. not sure how can i debug the issue as well.

 

kmanku

Hi,

 

Emp is  active and Salary and Bonus % is exist, i have checked all that. 

i have removed the if condition and checked as well.

 

Regards,

Kiran.

kmanku

thanks for the response, i did check the SYS08 module it has data in department and Role data populated. 

jessmathomas

I am having the same issue. I added in my updated formulas for bonus, car costs, phone costs, and medical costs and did not get an error message. Instead, the values are just zero. I think it has something to do with the formula column being blank in SYS08 (SEE ATTACHED).

MAwude2010

Hi Jess,

 

How did you progress with the training? Im having same issue loading Roles into SYS08

 

Please help if you have managed to overcome this issue