Need assistance in Formula

Question

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

L-1_59120.PNG

P-1_59120.PNG

L-2_59120.PNG

M-1_59120.PNG

Misbah · Accepted Answer

@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 · Accepted Answer

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