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
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
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, I will try with Module too.