Skip to Content
0
Former Member
Apr 29, 2008 at 02:13 PM

Webi reports - Problem exporting to excel

254 Views

HI,

I have exported a webi report as an excel file. The report contains a column with numeric values preceded by a dollar sign. After exporting to excel, i want to calculate the sum of the values in that column. However some cells show a numeric value, while some others show string value (i.e. text) because of which I am not being able to calculate the sum. Please help.