SUM QUESTION

Dear all,

I need some help to create a target module.

Currently, I have the following modules:

Source module with the following dimensions: products (list) and Time (Month). 1 line item : Quantity
Mapping module with the following dimensions: products (list). There are 2 lines items : Site and Molecule
I have created the target module with the following dimensions : Site and Molecule and Time (Month).

There is 1 line item: total Quantity = Source module. Quantity [SUM: Mapping module.Site; SUM: Mapping module.Molecule]

It works but I would like to create a target module without the site as dimension, only Molecule as dimension and get the quantity by Molecule only if site = site #1.

I've tried : IF Mapping module.Site = Site.site#1 THEN total Quantity = Source module. Quantity [ SUM: Mapping module.Molecule] ELSE 0

But it doesn't work, I've got 0 as result.

Many thanks for your help.

Claire

Accepted answers

All comments

andrewtye

Hi @ClaireO - got a couple of options either a list subset just for site #1 and then can have the same line item or have a Site 1 only mapping line item in the mapping module - so if site = site1 then molecule else blank.

ClaireO

Thank you for your help Andrew. I think I understand the first option. But the second option looks like what I did:

Source module with the following dimensions: products (list) and Time (Month). 1 line item : Quantity
Mapping module with the following dimensions: products (list). There are 2 lines items : Site and Molecule
target module with the following dimensions : Molecule and Time (Month). There is 1 line item: total Quantity = IF site=site1 THEN Source module. Quantity [SUM: Mapping module.Molecule] ELSE 0.

And I can’t make it work.

Or maybe should I set up this option:

Source module with the following dimensions: products (list) and Time (Month). 2 lines item : Quantity and Quantity(only if site1)
Mapping module with the following dimensions: products (list). There are 2 lines items : Site and Molecule
Target module with the following dimensions : Molecule and Time (Month). There is 1 line item: total Quantity = Source module. Quantity(only if site1) [SUM: Mapping module.Molecule]

Thanks for your help

Claire

Quick Links

Can you help?

Unanswered questions

I am getting error while submitting the assignment,please give me suggestion.
Please suggest why it is not taking submit.
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
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.…