When trying to calculate the total Sum of a column of values downloaded in Excel (XLS format) from Virtual Office Analytics using the Sum tool, the total Sum is always zero.
- Virtual Office Analytics
- Microsoft Excel
Download your report file in CSV format rather than XLS.
CSV format is offered as standard but your computer settings may need to be changed to open this type of file as a CSV rather than XLS.
The report was exported as XLS format instead of CSV.