Need assistance in Formula

Sravan_Kumar

Dear Friends,

I have some products and each territory allocation.

I want my final module to look like M-1

I have attached .csv file (P1) for reference

Regards,

S K

Accepted answers

Misbah

@Sravan_Kumar

If you are using both the lists as a dimension in the target module, then the formula Should be just the multiplication of your allocation % module (States module) and data module ( Cold Drinks Module)

State Sales = Allocation %.Provincial Allocate * Soft Drinks.Sales.

Note: Per Best Practices use module line items and not list properties to stage any data.

Hope that helps

Misbah

Yash1

Hi @Sravan_Kumar ,

You may use the formula:

'020. Soft Drinks'.Sales * '020. Allocation%'.Provincial Allocate

But as @Misbah correctly mentioned, the best practice is to use modules to store data.

Hope this helps.

Thanks,

Yash

All comments

Misbah

@Sravan_Kumar

State Sales = Allocation %.Provincial Allocate * Soft Drinks.Sales.

Note: Per Best Practices use module line items and not list properties to stage any data.

Hope that helps

Misbah

Yash1

Hi @Sravan_Kumar ,

You may use the formula:

'020. Soft Drinks'.Sales * '020. Allocation%'.Provincial Allocate

But as @Misbah correctly mentioned, the best practice is to use modules to store data.

Hope this helps.

Thanks,

Yash

Sravan_Kumar

Thanks, I will try with Module too.

Quick Links

Can you help?

Unanswered questions

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…