I am very new to Infomaker and Sql information to begin with, but I am having a hard time wrapping around computed columns. I am working on the below.
I have contracts for items and I want to calculate the amount of the item that we have purchased this item. (multiple contracts, for multiple customers, appearing on mulitple invoices, for multiple items) see attached pic.
What I need is, if the Item ID, Customer Name and Contract no are all the same I want them to sum the invoice qty (last column on the pic).
Right now what it is doing is making another row of information for every item when it appears on an invoice. I want it to maintain one row and increase the final column every time it appears on an invoice.
Please advise if there is an easier way to handle this or if you have a way to point me in the right direction, been googling and watching youtube for days and can't find a proper solution for my exact case.