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

Options
kmanku
kmanku Member, ALL USERS Posts: 4 New Contributor
in Planning & Modeling

 

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.

 

 

Tagged:

Comments

  • kmanku
    kmanku Member, ALL USERS Posts: 4 New Contributor

     

    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_0-1587740688637.png

     

  • kmanku
    kmanku Member, ALL USERS Posts: 4 New Contributor

    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
    kmanku Member, ALL USERS Posts: 4 New Contributor

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

  • jessmathomas
    jessmathomas Member, ALL USERS Posts: 1 New Contributor

    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
    MAwude2010 Member, ALL USERS Posts: 2 New Contributor

    Hi Jess,

     

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

    MAwude2010_0-1643897354675.png

     

    MAwude2010_1-1643897379127.png

    Please help if you have managed to overcome this issue

     

Categories