First Field -> data.Page1.Position.ITEMS.TOTAL
Field Subtracted from First -> data.Page1.Position.ITEMS.SALE
Calculation field -> data.Page1.Position.ITEMS.NEW
Any ideas how this can be done, or if it can?
Then I would like to hide the field if the calculated value comes back as zero, or empty. So I was going to try on the "initialize" event to add,
Formcalc should be easiest if you are just subtracting fields to get an answer in another.
In the NEW calculate event it is simple as:
TOTAL - SALE
Thats all you need. As figures are changed in the TOTAL and SALE fields, the NEW field will update dynamically. It will also be automatically changed to read only so it cant be modified.
Hiding the field will need to be done in the field itself. It will only initialise when the form opens. If you want it to hide dynamically with the field's rawValue, put it into the calculation event also.
You might need to account for getting the hidden field back as well if it isnt zero with an else on your if statement.