Level 1 exam formulas to the Line items

Mao0511
Occasional Contributor

Level 1 exam formulas to the Line items

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

 

4 REPLIES 4
MarkWarren
Expert

Re: Level 1 exam formulas to the Line items

Its saying you don't have an "Employed ?" line item. Create this boolean first.
Mao0511
Occasional Contributor

Re: Level 1 exam formulas to the Line items

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

JaredDolich
Master Anaplanner/Community Boss

Re: Level 1 exam formulas to the Line items

@Mao0511 

Your first equation looks right but that formula is meant for EMP02 module. Also in the EMP02 module is the Employed? Boolean.

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

Employed? = Started? AND NOT Left?

The REP04 module then uses the EMP02 module as a reference

'EMP02 Employee Expenses'.Salary[SUM: 'SYS08 Employee Details'.Region, SUM: 'SYS08 Employee Details'.Role]

See if that helps.


Jared Dolich
Mao0511
Occasional Contributor

Re: Level 1 exam formulas to the Line items

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

Many thanks,

Mao