Rounding KF

[Former Member]

Hi All

Rounding is not working on my query on 3.5Bex.Changed the number of decimals to 0.000 but still working.

Is there any settings need to be changed.

Regards,

Ramana.

[hai_murali_here · Accepted solution]

Hi Raman,

Even I tested this scenario with 3.x Query.I think this could be a defect with 3.x BEx Analzyer.

1.Opened the Properties dialog of a Keyfigure in 3.x QD

2.Set Number of Decimal Places as "0.000"

3.Opened the query in BEx 3.x Analyzer -> The changes are not getting reflected in BEx Analyzer

4.Launched the query in Web Analyzer -> The changes are getting reflected properly with Web Analyzer

Rgds,

Murali

[Former Member · Accepted solution]

Hi Murali

Thanks for the response.

Is there any temporary solution for this bug or what we could do about it.

Ramana.

[hai_murali_here · Accepted solution]

Hi,

Yes,you can do that.....

1.Open that query in BEx 3.x Analyzer

2.Go to Business Explorer->Tools->Query Designer

3.Open that query and change the Decimal place for the Keyfigure to "0.000"

4.Click "Quit and Use Query" icon in 3.x QD

Now you will get the data based on the decimal places set.

This will work.Please try it!

Rgds,

Murali

[Former Member · Accepted solution]

Hi Murali

The query showing 3decimals on the result but it's not roudning the value.

Means If the values is 100.56 then it should show 101.00 on result of the query.

Regards,

Ramana.

[hai_murali_here · Accepted solution]

Hi,

Set the Number of Decimal Places as "0".

This will round of the value

Eg:

If you have 100.56,it will round it off as 101,and not 101.00

Rgds,

Murali

[former_member189638 · Accepted solution]

Don't set any decimal place for the current KF. Just go to the properties and hide it

Now create a new formula and set the decimal places to 0 in the properties and use the following mathematical functions in the formula.

( FRAC ( 'KF' ) < 0.5 ) * FLOOR ( 'KF' ) + ( FRAC ( 'KF') >= 0.5 ) * CEIL ('KF')

Hope this helps.

[Former Member · Accepted solution]

Thanks Rakesh.

Working Fine.