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

 

 

 

Best Answers

  • Misbah
    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
    Answer ✓

    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

     

Answers