Skip to Content
Former Member
Apr 25, 2007 at 09:43 PM

Grand Totals or ???


Post Author: mklafert

CA Forum: Formula

My formula field for commission works great and I can get a grand total. Commission formula is :

commission = If {LineItem.HasCommission}=TRUE then {JrnlRow.Amount} *-1

non-commission = {JrnlHdr.MainAmount} - Sum ({@commission}, {JrnlHdr.Reference})*1 - Non-commission is taking the total of the invoice (main amount) and subtracting the commission amount.

comm amt. = Sum ({@commission}, {JrnlHdr.Reference}) * .10 - this field is the commission amount times .10 (10%),which is the commission amount paid.