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
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
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
Thanks, I will try with Module too.
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
