Skip to Content

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

% Format in Crystal IX

In a cross-tab report, I have a count displayed as a percentage of the total count and I have a sum displayed as a % of the total sum.

I am able to format the % of the total sum to show two decimals (example 6.91%). However, the % of the total count will not save my formatting. It reverts back to a whole number (example 4%). I can live with this if necessary, but I can't get it to round up. If the % is really 4.50, I want it to round to 5).

Any ideas?

replied

Hi Diann,

I had this problem too and it drove me insane. Luckily I found the solution. It's a known issue and there is a work around. Here is the link.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/10be47f7-711e-2b10-0e94-b145136ad876

If for some reason this link doesn't work, type in a search for crosstab percent at the very top of this page and it should be the first article.

Hope that helps,

Cyndi

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