Excel Formula output as number not string Totals

Stimulsoft BI Designer discussion
Post Reply
luke
Posts: 42
Joined: Fri Jun 03, 2022 6:57 am

Excel Formula output as number not string Totals

Post by 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
Attachments
Report.xlsx
(9.83 KiB) Downloaded 137 times
Max Shamanov
Posts: 767
Joined: Tue Sep 07, 2021 10:11 am

Re: Excel Formula output as number not string Totals

Post by Max Shamanov »

Hello,

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

Thank you.
Post Reply