In as much detail as
Description: - Weighted averages are heavily used in cost sheet KPIs (e.g., Cost Rs/T, SPC Kg/T, Rate Rs/T) across tracks in TSL. The current workaround is a numerator/denominator + RATIO and Formula summaries approach, requiring 2–3 extra line items per calculation (numerator, denominator, final weighted average). For example, 8–9 weighted average measures in an area result in ~27-line items in a single module only. This must be repeated for all business tracks (7–8 areas) and multiple cost sheets/modules. Each track has ~100 cost sheets including (ABP, Actuals, BPM, Plan vs Actual, ABP vs BPM vs Actual) with 20–25 cost sheets each having multiple product-level measures. This leads to hundreds of additional line items, consuming workspace and increasing build/maintenance efforts even for Anaplan’s Native time while we will be needing this summary option for both Native and Custom Time Dimensions.
Current Workaround Example: - Please find the steps involved to show the time weighted Average Summaries for a single line Item: Cost (Rs/T) = Amount/Production (or this can be referred from another module directly)
it is getting used very frequently in most of the KPIs in cost sheets like: Cost(Rs/T), SPC(Kg/T) etc.….
Impacting almost every stakeholder (model builders, solution architects, partners, admins, integration experts, business/end users, executive-level business users, Workspace size is getting increased and performance decreased.)
I think there should be a native weighted average summary option available which can work similar to Ratio's summary in which we can select the line items who's weighted avg or sum-product summaries we want to calculate. It will make life easier of module builder as they can use it directly without using extra line items which will subsequently lead to less consumption of space and overall performance of model will be enhanced.
All the details are available in the attached document with examples.
