How to force calculated field value to be in decimal notation

[ad_1]

Hello @jayceezay

Please use the PREC operation.

PREC(X, Y) rounds the number X with Y decimals. The PREC operation supports a third parameter with the value true or false (false is the default value). If the third para parameter is true and X is an integer number, the PREC operation returns the integer number without decimals. For example, if you have the operation fieldname1+fieldname2, and you want the result with four decimal places, you can edit it as follows:

PREC(fieldname1+fieldname2, 4, true)

Best regards.

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer