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
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
