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

  • 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

     

  • 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

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In