Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Decimals in Analysis Charts

Hello Experts,

i have the problem that for datasources/crosstabs that contain values which never have decimal places still show decimals in the chart component of analysis. The values that i mean here are those that are displaed when you hover over for example one bar in a bar chart. This can however be fixed if you use the excel function to change the cell type to "text" but after refreshing the datasource this is overwritten again. Is there a possibilty to set this for the chart/crosstab/datasource fixed? So that it would never show decimals?

Thanks in advance for your help!

Best Regards,
Dominik Herrmann

replied

Ok i think i found the problem the format that is handed over to Excel by Analysis is defined in the format set (SAP Blue or SAP Styles etc.). If i export one of those as XML i can change the decimals for "SAPDataCell" in the file and reupload that with a different name. If i then use this format set in my Workbook the graphic shows no more decimals.

Thanks for your quick replies Tammy.

Best Regards
Dominik

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question