Level 1 exam formulas to the Line items

Options
Mao0511
Mao0511 Member, ALL USERS Posts: 5 Occasional Contributor
in Planning & Modeling

I am trying to update the formulas but it shows error. What is wrong for this formula?

 

The formula for 'REP04 Employee Expense Summary'.Salary is invalid:

Salary = IF Employed? THEN 'SYS08 Employee Details'.Current Salary / 12 ELSE 0

Mao0511_0-1613480754509.png

 

Tagged:

Comments

  • Mao0511
    Mao0511 Member, ALL USERS Posts: 5 Occasional Contributor

    Can I use If Employees# Because in the line item Employees#, I would have a Boolean that would equal true or false, thus Anaplan would think that I am writing If employees# =true then …else ….

    But the formula shows error and can not find the correct formula. What is wrong this formula below?

     

    IF Employees# THEN Salary [LOOKUP: 'SYS08 Employee Details'.Role LOOKUP: "SYS08 Employee Details'.Region] ELSE 0

  • Mao0511
    Mao0511 Member, ALL USERS Posts: 5 Occasional Contributor

    Thank you very much for the explanations and it helped me to solve the issue!

    Many thanks,

    Mao

Categories