Skip to Content

Formatted search UDV decimal issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 15 at 09:30 PM

    Hi,

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

    Regards,

    Bala

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 18 at 06:59 PM

    Can you guide me how to go general settings?

    Add comment
    10|10000 characters needed characters exceeded

    • 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!

  • Mar 19 at 07:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded