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
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.
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
Thank you very much for the explanations and it helped me to solve the issue!
Many thanks,
Mao
When you inherit or start optimizing a large Anaplan model, what usually takes the most time? A. Understanding the existing model structure and dependencies B. Finding and optimizing slow or complex formulas C. Cleaning up unnecessary modules, line items, or lists D. Documentation and understanding why certain design…
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
The Anaplan XL Reporting formula reference page has not been updated since April 2026. It's missing any reference to the new XL3LookupAsync formula. Can we please have this page updated with all the latest features from XL?
