How to correct decimal problem in Query Designer

[pavneet_rana]

Hi to all,

Please can you tell me how to correct decimal problem in Query Designer.

Example: I have 2 fields and 1 formal at query designer.

        FIELD1                  FIELD2                     FORMULA

       140.469,74             11.705,81              FIELD2 * 12  = (140.469, 72)

So formula is FIELD2 * 12 = 140.469,72

But as per functional requirement FIELD1 value should be same as FORMULA value.

Also if we divide FIELD1 140.469,74 value from 12 it will give 11.705,81166….

So what to change at FIELD2 or at FORMULA so that it will give same value as FIELD1.

Is that decimal place problem or some thing else.

I shall be thankful to you for this.

Regards

Pavneet Rana

[Former Member · Accepted solution]

looks like a decimal problem , in your query go to field2 or formual its properties and display int to 2 decimal places.

[pavneet_rana · Accepted solution]

Thanks for reply,

I tried that but it didnot work, it only incress number of zero for decimal place.

Regrads

Pavneet Rana

[Former Member · Accepted solution]

go to rsd1 and see for your infoobject how many decimals are showing there. decrease it