Does anyone know if it is possible to add a "command" that will allow a (simple) calculation to happen in a field?
Currently I have an EDA, which has a form, allowing me to add a new record with a quantity I input and this gets added as a new record..
Off the back of this new record add, is a second part of the interaction where i need to also minus the same quantity from another field.
Example:
So, i add 4 items to a new record (PPO).
original field had 10, i need to have this show as 6.
eventually i get to 0 and will conditional style this when it reaches 0 to show all work is complete in dividing up this original record.
I did try but the field comes through as the actual numbers from the field and I was hoping for a calculation to take place with some sort of predefined "command" at the start perhpas?
I know it is probably not suitable for this but thought i would check just in case anyone else has done this.
These are the steps where it Adds a new planned PO record with a quantity and need that quantity removed in the next step
example (whcih i know doesnt work)
the "error" comes back with too many characters for the field "10.00000-4.00000" as it quite rightly takes the two values passed plus the -...
i was hoping there is maybe a cmmand i can add at the start to allow a calculation?
I can potentially do via other routes but wanted ot check here with you guys.
thanks
Tommy
