Trying to SUM revenue by account and product, getting datatype mapping error

Teddy5 · 2024-06-02T04:42:22+00:00

There was an error rendering this rich post.

I am trying to sum the revenue data in the "PY Account and Product Revenue" line item by account. Source and target module are both dimensioned by the same account>product combo list. I keep getting the same "Datatype mapping used for aggregation doesn't match any dimension of the result" error. Line item types are all correctly set to the appropriate lists. Don't understand why the SUM formula is not working. Thank you!

Accepted answers

shubhamrawat

Hi @Teddy5

Here, Sum will not work, as your source "PY Account and Product Revenue" and target "PY Account Revenue" line item are both dimensioned by A2 Account>Product#, and so is your mapping table "SYS03 Account>Product Details" module, simply use LOOKUP instead of SUM, it will give aggregated value for the Account.

Hope this helps.

All comments

shubhamrawat

Hi @Teddy5

Hope this helps.

Teddy5

Thanks, that worked! I guess I am missing the intuition behind why LOOKUP is a better choice than SUM here.

Teddy5

@shubhamrawat additionally, LOOKUP is not working when I try to aggregate by Product Family or by Country, presumably because the modules are not dimensioned by these. Though these line items are already loaded into my module, I am still struggling to aggregate revenue by these dimensions. Any suggestions? Thank you!

shubhamrawat

Hi, since this a training model, I can give you a hint, you might need an additional module with these dimensions from where you can lookup the revenue.

Also, you might find this useful for understanding SUM vs Lookup functions.

https://community.anaplan.com/discussion/533/when-do-i-use-sum-vs-lookup

Teddy5

Appreciate it, thanks!

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…