Allocation of indirect costs to several list items

Hello community,

I contact you regarding an issue of indirect costs allocation to several list items.

I have (fictive number) 10K€ of indirect costs categorized as “No checkout ID” which i want to allocate to each item of my item lists based on an allocation key.

To do so i’ve created 2 metrics based on 2 unique dimensions :
1. “Id_checkout” (Item list to which the direct costs and indirect costs are to be allocated)
2.  “Month” (because the allocation is based on a monthly basis)

First metric - Checkout level test - Consolidation of indirect costs
→ Filter on Indirect costs (“No checkout Id”)
→ Dimensions : Date (Month), Id_Checkout 
 

Second metric - Allocation Key Fees Test - Indirect cost allocation Key

→ Logic is to divide the direct costs allocated to each item list by the total cost of the month
1. Checkout level test - Direct cost per item - 2 dimensions (ID_checkout, Month)
2. Checkout level Fees for allocation key - Total cost per month - 1 dimension (Month)

→ It will give to each item list a weight in the total of fees of the month. We will use this weight to allocate the indirect costs.

 

Final metric - Concatenation of the 2 first metrics
→ “Checkout level test” multiplied by the “Allocation Key Fees” 

The issue is on this metric -→ There is no result whereas i should expect the below result :

Initial indirect : 
100 

Weight allocation : 
Item 1 - 50%
Item 2 - 10%
Item 3 - 40%

Final metric : 
Item 1 : 100*50% = 50
Item 2 : 100*10% = 10
Item 3 : 100*40% = 40

My hypothesis is an issue of Dimension somewhere on the several metrics, but i did not identified where.

thank you very much for your time and help.