Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

measure based on allocation key

Hi all, I have below matrix that shows per company the cost per category. This is straightforward data for Company 0-8.     However, we have a dummy company, company9, where cost needs to...
Need Help
Show and Tell
amustafa's avatar
amustafa
Solution Sage
2 years ago

See the sample file and the desired results in my shared drive.

Only relationship you have between the two tables are Compnay and Cost Object.

Cost Allocation

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

hi amustafa 

thanks for your help, but not really the desired outcome.

 

Desired outcome is to allocate costs booked on company 9 to all the other companies based on the allocation key. 

 

So for example we have category A booked on company 9 for an amount of 5000 that needs to be allocated based on the linked allocation key, for category that is S.2000.
S.2000 allocation is split between 4 companies and the key is as followed between company 1,2,3 and 4 (8/100/400/800). That 5000 should be linked to those companies as below :