RE: Issue in sum of currency column when download report in CSV

SSC Journeyman

Points: 78

November 6, 2014 at 3:15 am

HI,

issue is not related to currency display in report.Both Switch and IIF will work same way.Problem is when you sum different currency values in CSV it reads as text box instead of currency.

Ex: copy and paste below values in .csv file and try to sum these value,you will get 0

£ 7,607

£ 9,425

£ 163,656

and now copy and paste below values in csv file and try to sum these value,you will get summed value

€ 5,613

Regards,

Pushpendra Singh