Hello @stephenm
Thank you very much for the review.
Best regards.
Your welcome…..just a quick question is it possible on the free version for calculated fields to show messages based between to values? at the moment there is less then, greater then, equal to etc etc
Hello @stephenm
Yes of course, I guess you are talking about dependencies. Pay attention to the dependencies section in the settings of the calculated field, it includes a link for entering the rules manually. Pressing the link you can enter the conditions you want, but always using the “value” variable (that is a reference to the result of the equation).
Please, watch the following video, where I’m defining a hypothetical rule for the equation’s results between 1 and 100 (including them):
[video src="https://wordpress.dwbooster.com/customdownloads/2019/03/26/dependencies.mp4" /]
Best regards.
Many thanks will try that……much appreciated.
S
Hi there…..thank you for your recent support much appreciated…..we have one issue at the moment with a value been rounded to two decimal places….see form here….http://www.irishcement.ie/howto/calculator/
if if you enter the values 1 * 1.5 * 0.1 the volume output is 0.15000000000000002
we would like it rounded to 0.15
we would appreciated your help.
Stephen
Hello @stephenm
The issue you are reporting is caused by the way javascript manages the operations with decimals, the solution would be the use of the PREC operation, as the outermost operation in the equation:
PREC(X,Y) returns the number X rounded to Y decimals, so, in your specific example, where you want the result with 2 decimals:
PREC(1 * 1.5 * 0.1, 2)
Best regards.
Great thanks for the reply…..actually found that in one of your support emails!!
thank you very much.
S