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