My main table consists in several projects (Rows), each of these projects have a list of items with a common price (I am using another table with the price list per item).
I need now to display two things, first I want the standard values to be SUM up on the project and shows me the “Total Contractual Value” according to the amount of standard items added.
Second, I would like to add a variation price on top of each item on the price list, but this number should be related to the project, not the Item, the contractual value will never change but the grand total per project can.
Hope I managed to explain well,
Thanks in advance for the help