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
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…