Hi Guys;
We have a problem with number of decimals in formula on query bex, in the properties of the formula is set for example 0,00 (2 decimals), but the report shows 14,32987263 (many decimals).
Does anyone has happened this? we are on BW 7.4 SP 10.
Thanks for your comments!!.
César.
Hi Cesar,
Is there any characteristics structure available? If it is so then go to Properties->Display tab->Check No of decimal places.
you set the formula properties and no of decimal places (0,00) and in characteristics structure, no of decimal places (0,00000) then output will be decided by no of decimals in characteristics structure properties.
So output would be For Ex: 2,00000.
Hope you understood.
Thanks,
Swapna Jain
Yes, if you define two structures in the query. Both setting of decimal in column and row will play a role, and the one define last win. So you could try to set the formula decimal to another value, save, change it back to 0.00, save and see whether now formula get 2 decimal
Hi Cesar,
Try by creating ckf( Calculated key figure) rather than formula.
Regards
Swapna Jain
Hi Cesar,
Can you try to change Infoobject level in BEX explore tab,
There you can maintian decimals lentgh.
and try create formula in BEX level.
Decimal Places Setting in Bex Query Designer
Thanks,
Ram'S
Hi César.,
Could you please describe more details about this formula? What is the basic key figure settings?
How is it defined?
Thanks,
Giselle
Add a comment