Formula clarification required

Hi,

Can anyone help me out on understanding below formula what exactly it drives ?

Import Rebate Actuals.Gross Sales Amount[SUM: Import Rebate Actuals Map.Reporting GroupProductCustomer List, SUM: Import Rebate Actuals.Contract Name, LOOKUP: Reporting Contract Stage One.Contract Map]

Thanks,

Satish.

Accepted answers

All comments

nathan_rudman

Hello,

This is the sum of the gross sales amount by customer and contract name, only for the selected "Reporting Contract Stage One.Contract Map". It's comparable to a sumifs in excel

PaulRitner

Hi,

the statement is aggregating "Gross Sales Amount" into a module that contains (at least) "Product-customer" and "contract name" as dimensions.

The lookup part of the formula refers to a line item in a module that contains a value related to a dimension in the destination module (not actually a dimension in the destination), AND is a dimension in the source module (i.e. Import Rebate Actuals).

The sum statements always refer to dimensions in the destination (module). If the dimensions mentioned in the sum statement don't exist in the source (module), then they can often be defined in line items (in the source, or in a module that has dimensions aligned with the source)... for example "Import Rebate Actuals Map.Reporting GroupProductCustomer List" looks like a line item from a mapping module that is, at least, partially aligned with dimensions in the source... which allows Anaplan to (effectively) treat the two modules as if they were one for purposes of formulas. Mapping modules can be very handy provided they are used in a way that will scale well. I was at a client, for example, that created a variety of mappings that were contained in modules that weren't versioned, but were then embedded in formulas that applied different mappings to different versions... this is (and remains) very messy and difficult to work with... its on our cleanup roadmap.

Please let me know if this helped!

Cheers!

Paul

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
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.…