on 03-31-2008 11:07 AM
Hi all,
We have a field GR qty which is a key figure. When i check the value in data target its value is 0.500, but i execute a report,i see a value os 1.000
Can any one tel me if thr are any setting i have to make to correct this error.
Thanq all.
Regards,
Praveen
There should be a settings in Query designer properties to display decimal values, try that.
OR
Declare the key figure as FLTP data type, activate your infoprovider, TR/UR and check after that.
Hope it helps..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all,
Thanks for the replies.
GR QTY was giving the UOM EA(each).
Ex : 1.00 EA or 0.500 EA
So i used NODIM(GR QTY) in query designer. This solved my problem. i got 0.500/0.342 (wat ever present in target) in the output. But my client says he wants the units also to be displayed in the query output.
Pls let me know the possibilities.
Regards,
Praveen
Praveen,
Are you rounding off the value in the report ?
Check againt the number of decimals against the Key Figure
Arun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Praveen,
Are you using BI 7.0, which in case you might not deleted the PSA, and the line item is aggregating...
Pls check with PSA in DATASOURCE , clean it and reload the data...
Cheer's
HVR.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.