Data column number formatting in Excel

[Former Member]

Can I overwrite the formating for the data columns in excel?

For calculation purposes I need 2 decimal places defined for the data columns but when I display I dont want to see the decimals, I want to see the rounded number. But I cannot format this on the excel. Any suggestions?

Thanks!

Hema

[Former Member · Accepted solution]

I dont think you can do this in bi side,

but you can do that in macro to manipulate

the data the way you want it to be

Thanks

Wond

[Former Member · Accepted solution]

Thanks. But I dont want to use macros!

[Former Member · Accepted solution]

Hi,

In the definition of your planquery, go to the properties of your key figure and assign the number of desired figures behind the comma.

-> in your workbook if you click on your cell, you will see the number of figures behind the comma according to your info-object in the formula bar, but in the layout itself it is rounded according to your query settings

D

[Former Member · Accepted solution]

D,

Thanks for the suggestion. That solves the problem.

-Hema

[Former Member]

Hi,

In the layout settings, you can specify the decimals to be 0 for the data columns. When you use the figures in calculations, it will do a floating-point calculation only and not just integer.

[Former Member]

That doesnt help. Because I am doing the excel formula for calculation on the layout.