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
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
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.…
