Is it possible to overwrite a calculated field in an input table?

I have logic built into my form where the gross weight subtracts tare weight and then returns the net weight.  In some cases I don't have a gross weight and tare weight and want to manually enter the net weight, is this possible?

As you have found out already, because the net weight data was base on calculated value using condition, the manually inputted data will only will always be overridden by the calculation value.

The workaround that I found that can work is to add another column/input box in the table. Example, you can add the "manual net" column. It should not be calculated value.

The user can manually input the data in "manual net" box.

Then you can create another condition wherein if the "manual net" box is filled, override the value in the net box -- either set it to 0 or empty.

I hope this help. Let us know if you need further assistance.

Jonathan,

I have tried unsuccessfully to create logic where, if the manual net box is filled is will override the value in the net box.  Can you provide details for how I could do that?  Also, is it possible to request an enhancement that would allow a user to overwrite a calculated field with data if one of the fields used in the calculation isn't used?

Thanks,

Adam

Hi Adam,

Sorry for the delays. The workaround I was suggesting is something like this...

but unfortunately there is a problem with our condition calculations that was preventing the condition to work properly.

I have sent a bug ticket report to our higher team support so that they can fix the problem to make the condition work as intended.

For now, the nearest resolution I can suggest is to just use the alternative 'manual net' input as the input data source in place of "Net" if gross and tare input are empty/blank.

I hope this help. Let us know your thought on this.

Jonathan,

Any updates on this?  i created a clone of my settlement report that can be found here.  i added a new field named Recovered Net.  Gross and Tare are entered i want it to calculate the net and then multiple the net by price for the total.  If Gross and tare aren't selected I want to be able to enter a number in the Recovered Net field and have it calculate by price for the total. How can I accomplish this?

Unfortunately my colleague is currently not available online. Let me send a message to him and he will get back to you as soon as he is available.

Are there any updates to this?