I have created a birt report with amount along with currency as one of the column. The problem is that when we tries to see it in the excel, excel reports are showing the amount as "number stored as text" and thats why its not possible to make any calculations there. The amount data type in the reports are saved as decimal.
Pls suggest on the same. I'm attaching the report.
Number of downloads: 4