1 Reply Latest reply: Sep 2, 2010 3:01 PM by danhilz RSS

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

      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