When export to excel, Key figures formats them as text.

[Former Member]

Hi All,

When we try to export the report to excel from BI portal the format of Keyfigures show as text instead of Number.

We didn't have this problem before not sure what caused the changes. How do we get back to the number instead of text?

[Former Member]

Hi, Hima:

Take a look at OSS Notes 1591929 and 1739914.  We noticed the issue after applying 7.0 EHP1 SP8 PL31.  1591929 fixed the issue except for zero value key figures.  1739914 addresses that remaining issue.  We are currently upgrading to 7.3 and this was released in Week 41 as part of java SP8 PL20 for 7.3.

Regards,

Rex Foster

[Former Member]

Thanks Rex. We did open a message to SAP to fix the problem.