summary Report

Recommended Posts

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?

Share on other sites

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)

Share on other sites

"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?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

×
×
• Create New...