SydneyMcConnell

Hey, guys.

I'm in a software engineering class, and we participate in competitions with BPA, the Business Professionals of America. I am in the "Software Engineering Team" competition, with two of my classmates, and the project is an Accounts Payable system for a fake energy drink company, "Revcorp."

My current task for the program is the check writing. My weapon of choice is Crystal Reports.
I've got the layout and vendor information done, as well as the ability to obtain the items for the invoice the check is for and generate the check stub. The only thing left is getting the payment amount, which I must get from the Unit Price * Quantity Recieved, from the invoice.

So far, the closest I've been able to get is seperate aggregate functions on Unit Price and Quantity:


This returned a value. The only problem is that it's the wrong value.
So, I need to know if there is a way to do this, and if so, how?

Any help would be greatly appreciated.