Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have got a problem with distributing common costs accros a range of ZIP-Codes.
As you can see in the attached screenshot I've got certain revenue as well as certain costs which are each individually assigned to the according ZIP-Code, but I've also got this big overhead lumpsum, which I would like to spread accross each ZIP-Code as per the individual count of Jobs in each area.
Thanks in advance your help,
Kai
Hi, it could be something like:
Sum(TOTAL OverheadCost)/Count(TOTAL Jobs)*Count(Jobs)
So if you have OverheadCost=100, Jobs Zip1=3 Jobs Zip2=7
For Zip1: 100/10*3=30
For Zip2: 100/10*7=70
Hi, it could be something like:
Sum(TOTAL OverheadCost)/Count(TOTAL Jobs)*Count(Jobs)
So if you have OverheadCost=100, Jobs Zip1=3 Jobs Zip2=7
For Zip1: 100/10*3=30
For Zip2: 100/10*7=70
Thank you, i had completely forgotten about the TOTAL function...