Key figure in the exponential format is not getting displayed properly in BEX analyzer

[Former Member]

Hello all,

i have one Key figure '5,7293780999999999E-01' in exponential format. I can see the values at multi-provider level but when I am executing the query the results are getting added and I am getting the result row as "11,4587603". Can you please help me in this? I would like to display in the same format as I see at Multiprovider level.

Thanks and Regards,

Sarika G.

[former_member194898]

Hi,

Did you think about using a VB macro for changing data type in the column where that format is needed ?

Hope this helps, Leszek