Excel Formula output as number not string Totals

[luke]

Report line items with Excel formatting when exported to a spreadsheet display in numbers as expected but the totals when excel formation is added the numbers are being outputted as strings on the excel report.

Example of the formula used for the line items that are being exported correctly: {String.Format("{0:#,0.00}",ExpenseClaim.AMOUNTEXVAT)}

The Summary value that is displayed as a string in Excel: {String.Format("{0:#,0.00}",Sum(DataExpenseClaim,ExpenseClaim.AMOUNTEXVAT))} , How can i Format the Sum to Display in Excel as a Double.



The values in bold are totals

[Max Shamanov]

Hello,

Please send us a sample report with test data that reproduce the issue.

Thank you.