Excel Formula output as number not string Totals
Posted: Fri Sep 09, 2022 7:47 am
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
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