How close am i here???
The formula for 'REP04 Employee Expense Summary'.Salary is invalid:Salary = IF Employeed? LOOKUP :'SYS08 Employee Details'.Current Salary[LOOKUP: 'SYS08 Employee Details'.Role LOOKUP: 'SYS08 Employee Details'.Region] ELSE 0
@lcapon
Try using the SUM formula. You've already checked if the employee is employed? so you don't need to do that again.
Correct Formula
Salary = 'EMP02 Employee Expenses'.Salary[SUM: 'SYS08 Employee Details'.Region, SUM: 'SYS08 Employee Details'.Role]
Yours
Salary = IF Employeed? LOOKUP :'SYS08 Employee Details'.Current Salary[LOOKUP: 'SYS08 Employee Details'.Role LOOKUP: 'SYS08 Employee Details'.Region] ELSE 0
Hi Jared,
I used the formula but it still doesn't work and I'm not sure why. Hoping you can help.
Hi @julioarrastia, better late than never, click the blueprint view to edit the REP04 Employee Expense Summary module, the timescale of the line items should be set to Year not Month
what are these? when do you use them? why one over another? thanks Data types string long float bool date datetime datetimetz
Hello Anaplan Community, We are currently facing an issue related to certificate validation and would appreciate your help or guidance. We are getting the following error: Unable to build certificate chain for Cert [subject DN = EMAILADDRESS=********, CN=service account email address, cert serial number = XXXXX; issuer DN…
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-
