Question

Reports exported to excel have numbers with extra zeros (0)

We're running 8.1.3 and have a series of reports that work fine when viewing it in the report viewer.

Unfortunately, when we export these to excel. The values are inconsistent and don't work well with formulas.

We don't want to change all the values manually and we've already attempted editing the properties for the columns.

***Edited by Moderator Marissa to update platform capability tags****

Comments

Keep up to date on this post and subscribe to comments

Pega
October 9, 2019 - 12:07pm

Hi Mandaris,

Would you say that this appears to be a formatting issue - rather than a data issue?

That is: to fix this - are you using the EXCEL function "Format Cells > Number > Number > Decimal Places" on the whole sheet and re-saving it - or do you have actually edit the cells themselves?

It might help if you could:

- Upload an example EXCEL file here

- Confirm (with screenshots if possible) the exact steps you went through to generate the report.

(Presumably - you just ran a Pega Report - previewing it - and then did "Export To Excel"? - but should wanted to make sure).

I have uploaded a manually-created Excel file here - just to show what I mean by the formatting: I haven't tried 'Export To Excel' in 8.1.3 yet to see what happens.

 

 

October 11, 2019 - 1:46pm

Thank you John,

I've attached a scrubbed copy of the excel exported from PEGA. The key columns are Y - AC.

 

These are some screenshots of the steps that I'm doing.

Running the report.

 

Setting the filters (just to reduce the amount of results).

Finally, exporting to excel.

 

I suspect it has something to do with the fact that the values are stored as doubles and PEGA doesn't do formatting for doubles that are exported to excel.