Formatted search UDV decimal issue

[former_member197302]

Hi I have written below query for UDV - Formatted search

SELECT (( $[$38.53.Number] * $[$38.54.Number] * $[$38.55.Number] ) / 1000000)

This fields are height,width and length. I am dividing them with 1000000. But it gives me 0 answer. Now instead of division i use multiplication with value 0.000001 to get the same result it gives me 0.03

Here is an example

(38*18*38)*0.000001 = 0.025992 but I get 0.03 instead of 0.025992 . It is rounding up some how. And not able to figure it out why

[former_member225732]

Dear naman shah,

For this, you need to increase you decimal places for Query output and you can do it from below path:

Menu --> Modules --> Administration --> System Initialisation --> General Settings and check for Display Tab

Also please note that, this setting is not reversible, this will impact on all your query base report output where decimal points comes into picture.

Also make sure on which field you are applying it, it should have same decimal places length so it can be stored properly in database/table.

Hope you will understand it and apply correct solution after discussion with your client.

Best Regards,

Sandesh Shinde

[former_member197302]

Can you guide me how to go general settings?

[kvbalakumar]

Hi,

Menu --> Modules --> Administration --> System Initialization --> General Settings and check for Display Tab

At Display Tab, increase the decimals in query to your desired value.

Caution: You can only increase the decimals and cannot be decreased!

[kvbalakumar]

Hi,

At General settings, please increase the decimal places for Query from 2 to 6! It should do the trick for you.

Regards,

Bala