Forum Discussion

aalok29's avatar
aalok29
Regular Visitor
3 years ago

Prorating Fees to other Disciplines Proportionally

I want to reallocate all the "Unallocated" fees to other Disciplines proportional to their percentage contribution to the total.

For example:
Unallocated Net Fee Total = $350

Architecture % of Total = $1,900 / $2,725 = 69.7%
Hence, new Architecture Net Fee = $1,900 + (69.7% x $350) = $2,144

 

Similarly, I want to distribute the "Unallocated" Net Fee total to all other Discipline totals.