How should I form this formula?

EvaLagae
EvaLagae
in Modeling

I have the modula SYS08 employee details where my bonus% is 0 but I know the role and department.

image.png

And I have this modula EMP03 empolyee drivers by role where I know the bonus for every role

image.png

in the end I want to know the total bonus for the sales department in December. So I want to look in EMP02 Employee expenses to my line bonus

image.png image.png

Do you know which formula I can use to link the bonus to the department and role in the Sys08 modula and is my formula in the Emp02 correct?

Thanks in advance!!

Answers

  • araj
    araj

    Hi @EvaLagae

    To fetch the bonus% in SYS08 module by dept and role, you can use lookup function to pull the data from EMP03 module;

    For eg: SYS08 bonus% = EMP03.bonus%[lookup:SYS08.Department, lookup: SYS08.Role]

    Yes, your EMP02. Bonus% formula is correct.

  • EvaLagae
    EvaLagae
    edited April 9

    Hi, thank you for your help!

  • EvaLagae
    EvaLagae
    edited April 9

    Hi @araj, the formule is accepted but the fields are still 0% which is not correct. Do you see something else that I did wrong?

    image.png image.png
  • araj
    araj

    @EvaLagae , Please convert the "role" line item format into list format. Create a line item "Role list" and use finditem function and use list formatted line item in your Lookup.

    E.g: Role List = Finditem('Role List name', Role)

    image.png

Categories