No display 0 number when value is less than 1

[Former Member]

Hi all,

i've this problem, in our vc i-view we don't see the 0 number but only decimals after comma when the value of our keyfigure, that we take from BI query, is less than 1 ; for example:

KF value 0,16

in our i-view we saw ,16

if we test query on VC we see the correct results (0,16), if we test the query on Bex we see the incorrect result ( ,16)

Our VC client version 700.17

Any suggestions?

[Former Member]

Hi

You can try one numeric function 'FLOAT(Key figure string)'. In normal cases this is not required for 'Key figure' but you are not getting the value properly so you can try this.

regards

Sandeep

[Former Member]

Thanks for your suggestion but i've tried and the situation still to be incorrect.

Is it possible that is something in Bex settings? I've Bex BI add-on 7.x SP 7

I run the query on Bex 3.5 and the results is correct.

Any ideas?

Thanks

Roberto

Edited by: Roberto Ommenetti on May 18, 2009 9:44 AM

Edited by: Roberto Ommenetti on May 18, 2009 12:31 PM

[Former Member]

Problem fixed using as data fields the calculated key figure type T instead the type N (CKF_value).

Roberto