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

Accepted answers

JaredDolich

@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.

All comments

MarkWarren

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

Mao0511

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

@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.

Mao0511

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

Many thanks,

Mao

Quick Links

Can you help?

Unanswered questions

Module Information Visibility Restricted for Non‑Admin Users on Anaplan page
Why are non‑admin users unable to view Module information on the Anaplan page, while workspace administrators can? (After click the three dots on the grids right up corner) Are there any configuration options that allow non‑admin users to view module details without granting full workspace administrator access?
How to synchronize scroll a card/s from the main board and another card/s in the insights panel?
Just like the main question above, I wanted to try out the new feature on the board where you can you the insights panel to put additional cards. However, I wanted to synchronize scroll a card on the main board with the card on the insights panel but I can't find where it might be.
ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…