Excel reports from SharePoint2013 Reporting portal display percentages as decimals in browser

%3CLINGO-SUB%20id%3D%22lingo-sub-2593718%22%20slang%3D%22en-US%22%3EExcel%20reports%20from%20SharePoint2013%20Reporting%20portal%20display%20percentages%20as%20decimals%20in%20browser%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2593718%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EWe%20have%20SharePoint%202013%20BI%20and%20reporting%20site%20with%20Excel%20Services%2C%20which%20amongst%20all%2C%20hosts%20few%20Excel%20reports.%3C%2FP%3E%3CP%3EReports%20contain%20chats%20displaying%20data%20as%20percentages.%3C%2FP%3E%3CP%3EThe%20reports%20are%20formatted%20correctly%20and%20the%26nbsp%3B%20percentages%20are%20displaying%20correctly%20when%20the%20report%20is%20viewed%20in%20Excel%20Windows%20app.%3C%2FP%3E%3CP%3EI%20went%20through%20the%20reports%20and%20made%20sure%20that%20all%20percentage%20fields%20are%20formatted%20as%20percentages.%3C%2FP%3E%3CP%3EBut%20when%20the%20users%20are%20viewing%20the%20report%20in%20Browsers%20-%20the%20percentages%20are%20shown%20as%20decimals.%3C%2FP%3E%3CP%3ETill%20recently%20all%20reports%20displayed%20correctly%20and%20couple%20of%20weeks%20ago%20started%20to%20display%20the%20percentage%20figures%20as%20decimals.%3C%2FP%3E%3CP%3EHere%20is%20an%20example%3A%3C%2FP%3E%3CP%3EChart%20viewed%20in%20Excel%20(windows)%3A%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22RSWork_0-1627461546330.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298903i6749E84774E2E7DF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22RSWork_0-1627461546330.png%22%20alt%3D%22RSWork_0-1627461546330.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20above%20viewed%20in%20browser%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22RSWork_1-1627461679412.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298905iA099A6DD17437B58%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22RSWork_1-1627461679412.png%22%20alt%3D%22RSWork_1-1627461679412.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFormatting%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22RSWork_3-1627461906872.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298909i5CD0AE857BD29260%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22RSWork_3-1627461906872.png%22%20alt%3D%22RSWork_3-1627461906872.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22RSWork_4-1627461967895.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298910i2DE9EE769AC22004%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22RSWork_4-1627461967895.png%22%20alt%3D%22RSWork_4-1627461967895.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20cannot%20figure%20why%20and%20how%20to%20fix%20and%20that%20is%20causing%20problems%20for%20the%20users%20consuming%20the%20reports.%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPS.%20Also%2C%20can%20I%20stop%20user%20checking%20out%20the%20reports%3F%20They%20forgot%20to%20check%20in%20and%20lock%20the%20reports...%3C%2FP%3E%3CP%3EBest!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2593718%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EApp%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi All,

We have SharePoint 2013 BI and reporting site with Excel Services, which amongst all, hosts few Excel reports.

Reports contain chats displaying data as percentages.

The reports are formatted correctly and the  percentages are displaying correctly when the report is viewed in Excel Windows app.

I went through the reports and made sure that all percentage fields are formatted as percentages.

But when the users are viewing the report in Browsers - the percentages are shown as decimals.

Till recently all reports displayed correctly and couple of weeks ago started to display the percentage figures as decimals.

Here is an example:

Chart viewed in Excel (windows):  

RSWork_0-1627461546330.png

 

The above viewed in browser: 

RSWork_1-1627461679412.png

Formatting looks like this:

RSWork_3-1627461906872.pngRSWork_4-1627461967895.png

I cannot figure why and how to fix and that is causing problems for the users consuming the reports.

Any ideas?

 

PS. Also, can I stop user checking out the reports? They forgot to check in and lock the reports...

Best!

0 Replies
We support Ukraine and condemn war. Push Russian government to act against war. Be brave, vocal and show your support to Ukraine. Follow the latest news HERE