formula to get total salary by role and region

Hello,

what is the correct formula to get the total salary by role and region? in the source module EMP02, the timecard is "month" and in the target module REP04, it is "year". Aside from the timecard difference, my formula is not correct. any advice?

Screenshot_11-7-2024_81116_us1a.app.anaplan.com.jpeg

Screenshot_11-7-2024_81159_us1a.app.anaplan.com.jpeg

Accepted answers

Dikshant

Your target dimension module has Role and Region list applied, so sum your salary and other expenses by Role and Region. Use SUM functions and take the role and region mapping from EMP02 module.

All comments

seymatas1

Because you are moving data up to a less granular time (month → year), your formula will work in the time dimension if your time summaries are on.

However, you should check your other list dimensions:

EMP02 Employee Expenses: Dimensioned by E2 Employees
REP04 Employee Expense Summary: Dimensioned by Role and G1 Region

You should tell Anaplan the regions and roles of these employees through the SYS08 Employee Details module.

You are "summing" the employees up by their roles and regions!

Dikshant

Your target dimension module has Role and Region list applied, so sum your salary and other expenses by Role and Region. Use SUM functions and take the role and region mapping from EMP02 module.

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
Introducing Anaplan API Python SDK
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…
Cloudworks Big Query Integration Fail
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…