Totaling an invoice's details, then divide that number by one invoice detail.

[#1]

I'm looking for a way to total numbers in a invoice record detail, then divide that number by one invoice detail.

Invoice #1

Rep A CommisSplit % 40
Rep B CommisSplit % 30
Total CommSplit % 70

Divide Rep's CommSplit % 40%
By Total CommSplit % 70% =57.14%

Thanks

[#2 · Accepted solution]

I solved my own problem by
first adding the eligible salesrep candidates commission split % numbers together then dividing that number by the eligible salesperson's commission split %.