Jump to content

This topic is 7603 days old. Please don't post here. Open a new topic instead.

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?

Link to comment
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)

Link to comment
Share on other sites

This topic is 7603 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.