Simple question, please what’s the formula to multiply 2 edit fields, I tried field1*field2 but it not seem to work.
Thanks
Simple question, please what’s the formula to multiply 2 edit fields, I tried field1*field2 but it not seem to work.
Thanks
Subject: Multiply function
What error do you get? Are they both number fields? If you’ve got 2 editable text fields with “15” and “3” in them if you try
field1 * field2
you’ll get an error if you try to multiply them, however
@TextToNumber(field1) * @TextToNumber(field2)
will give you 45
Subject: Multiply function
Actually you should make them number fields to begin with. Otherwise they can enter a text value and the multiply function will fail then, even with the above fellows formula.