Highlighted
Regular Contributor

Need assistance in Formula

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

 

Sravan_Kumar_0-1580662074349.pngSravan_Kumar_1-1580662095475.pngSravan_Kumar_2-1580662110638.pngSravan_Kumar_3-1580662126522.png

 

 

 

3 REPLIES 3
Highlighted
Community Boss

Re: Need assistance in Formula

@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

 

Highlighted
Frequent Contributor

Re: Need assistance in Formula

Hi @Sravan_Kumar ,

 

You may use the formula:

 

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

 

Yash1_0-1580685705856.png

 

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

 

Hope this helps.

 

Thanks,

Yash

 

Highlighted
Regular Contributor

Re: Need assistance in Formula

Thanks, I will try with Module too.