total seems to be wrong

Hello Anaplanners

The result of the calculation seems to be wrong.

In fact is question 6 from model builder exam1.

the formula should return the sum of expenses based on hierarchical level and region,

However, in my result, I only get the total displayed, independent which selection is applied.

I assume the the selection does not work as I might have missed some settings.

In fact it was mentioned in the lesson, 8.6.2, source has additional lists, which is I think is my issue, but I did not find the solution...😒.

Kind regards, Tutto.

ANAplan_REP04_20210714_114091.png

Accepted answers

All comments

MarkWarren

in REP04 the intention is to bring in data that relates to the Region and the Role (these are your dimensions). This information is not in EMP02, you just have Employees.
This means you need to SUM the data using mappings, how/where does Employee map to Region or to Role.
You will also need to change the Summary options in REP04 from Formula to SUM.

Hexagon1

I see, the EMP02 shows the values for the two dimensions, but cannot filter or distinguish them.

Now having referenced to the SYS08 where the two dimensions are in, it actually work.

Many thanks for the hint.

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…