RustySunset
Technical User
Using Crystal X with a SQL database.
I'm working on a salesperson commission report. I have details about invoices, commission amount by invoice and payment info. There are two groups - {table2.SperID} is group 1 and {table2.OrderID} is group 2. I have a calculation at the second group {table2.OrderID} to calculate the remaining commission for each order based on the total commission for the order, less the commission paid on this report. My formula in the {table2.OrderID} group footer is; {table1.Sper1_Rate} - Sum ({@Prior_Comm_Pd}, {table2.SperID}) - Sum ({@Current_Comm_Amt}, {table2.SperID})
I would like to have a group sum total at the {table2.SperID} group #1 but the when I attempt to insert the sum I can't pick sum...just max, count, min etc.
I'm working on a salesperson commission report. I have details about invoices, commission amount by invoice and payment info. There are two groups - {table2.SperID} is group 1 and {table2.OrderID} is group 2. I have a calculation at the second group {table2.OrderID} to calculate the remaining commission for each order based on the total commission for the order, less the commission paid on this report. My formula in the {table2.OrderID} group footer is; {table1.Sper1_Rate} - Sum ({@Prior_Comm_Pd}, {table2.SperID}) - Sum ({@Current_Comm_Amt}, {table2.SperID})
I would like to have a group sum total at the {table2.SperID} group #1 but the when I attempt to insert the sum I can't pick sum...just max, count, min etc.