I need a way to calculate a new contract price based off a previous form. For the form, I have “Original Contract Price” “Price of Change” and “New Contract Price”. I need the New Contract Price to Calculate Original Contract Price + Price of Change + Price of Change from all other forms associated with the Job Name. Is there a way to make this work?
Let’s assume that every time you record a submission with the form, the value is a given value. It turns out that each line belongs to a job.
What do you base your cost increases on? On the latest date, that is, the last contract or the most expensive contract.
Based on that answer, the solution will be there. You need to find the previous value and, through a search, obtain the contract value that the current form will use to add to the new value.
If you haven’t solved it, perhaps I can help you structure the expressions. Best regards.
1 Like
I was able to figure it out using this formula. It sums the Price of Change column values for rows in the Change Order data set in which the Location of Work column value is equal to the Location of Work column value in the current form.
1 Like