Hello @benh123
If you have a number field, and you want the plugin to apply the format entered into the field’s settings, you should tick the “Format Dynamically” checkbox.
Best regards.
No what I mean is, if the user enters 2200 I need the calculation to work as 2.200 if that makes sense?
Hello @benh123
If you want to use the point as the symbol for grouping thousands, you can enter the point symbol . into the “Symbol for grouping thousands” attribute and the comma symbol , into the “Decimals separator symbol” attribute.
Best regards.
Sorry not sure you understand what I mean.
I need the form to recognise 2200 as 2.200 so that the calculation works. It gives a result of 261360840 when it should be just 2613.
Thanks,
Hello,
In short, you want to divide a field’s value by 1000. So, assuming the field name is fieldname1, the equation would be:
fieldname1/1000
If you want the result with three decimal places when the number is not an integer, the equation would be:
PREC(fieldname1/1000, 3, true)
Best regards.
