Skip to Content
0
Nov 20, 2012 at 02:47 PM

How to correct decimal problem in Query Designer

17 Views

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