Rounding a decimal value to 3 digits

[Former Member]

I have opened a UDF and copied the value of Total (LC) column in that field. I want to round off the copied value to 2 digits.

Below is the query written to copy the value.

SELECT ($[$38.21.NUMBER] * $[$38.U_GST.1.11]) / 100

Below is the query written to ROUND the value.

SELECT ROUND(($[$38.21.NUMBER] * $[$38.U_GST.1.11]) / 100, 2)

Thanks & Regards,

[Former Member]

Try: SELECT ROUND(($[$38.21.NUMBER\] * $[$38.U_GST.NUMBER\]) / 100, 3)

However, I think it is probably not working because B1 has internal checking to make sure the decimal value follow your setting. If you setup your currency by 2 decimals, you may never get any additional decimal place.

Thanks,

Gordon

[Former Member]

SELECT ROUND(($http://$38.21.NUMBER * $http://$38.U_GST.1.11) / 100, 3)

[former_member196081]

Hi,

SELECT ROUND(($http://$38.21.NUMBER * $http://$38.U_GST.1.11) / 100, 3)

Regards

Deepak Tyagi