I am producing a summary report. In the report I have 8 columns which are:

Name------constant-----Price-------Comm----Expense----net----deduct----total

USA Motors---1------2000.00-------200.00---35.00-----1765.00----0------1765.00

USA Motors---1------1500.00-------150.00---35.00-----1715.00----0------1715.00

USA Motors---1------5000.00-------250.00---35.00-----4715.00----0------4715.00

-------------------------------------------------------------------------------

USA Motors---3------8500.00-------600.00---105.00---7795.00-5000=2295.00

------------------------------------------------Summary Net-Deduct=Summary Total

Deduct 5000.00 = Bought two vehicles at same sale for 2000.00 and 3000.00 each.

Name is the name of the car dealer, Constant is the line item, Price is the price of the vehicle, Comm is the commission we make off the sale, Expense is the expenses incurred in selling the vehicle, net = price - constant - Comm - Expense. The Deduct is when a dealer purchases more vehicles at the same sale and wants to deduct the total amount of his purchase from his summary net and this will give him the total. Now the only problem that I am having is that the Deduct is only one number and not a line item, so it cannot be included with the line item, but I need to be able to put it in the equation so that the summary net - deduct = Summary Total. Is this possible?

Hi,

Not sure I fully understood...

Are these 3 lines related to a Sale_ID or Session_ID ?

You could introduce within the Line Item a related calculation based on the Session_ID.

Count(SelfjoinOnSession_ID::Record_ID).

This count would populate how many cars the user purchased within the session.

If your buyer want to deduct the total amount of his purchase from his summary net, you would use a checkbox (yes/no), and the deduct would be filled by calculation using a Case Statement.

Case(checkbox = Yes, amount, 0)

"Deduct 5000.00 = Bought two vehicles at same sale for 2000.00 and 3000.00 each."

Where and how is this information stored? Does every vehicle have a deduct?