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.
We're looking to feed live or near-live Anaplan data into Claude through MCP, but our current approach — exporting CSV files via the Anaplan Bulk Export API, loading them into MySQL, and querying from there — has a significant lag (hour-long turnaround). Curious if anyone has found a faster path, whether that's through the…
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
