Pivot table : problem with function SUM, i get "infinity"

Webix JS
1

I’m trying to pivot a table with WEBIX and compare result with EXCEL. When applying function COUNT on values everything’s fine and i have the same result with EXCEL but when i apply function SUM i have infinity in most of cells with WEBIX and things still fine with EXCEL.

2

Could you please provide an example of your pivot and its datasource ?

Possibly there is a problem with values. Values must contain only numbers and “.” as decimal separator. And Excel applies data format according to the locale settings ( for example there can be “,” as a decimal separator).

3

Datasource : http://devfree.byethost9.com/print_scr/datasource.png

Excel result : http://devfree.byethost9.com/print_scr/excel_pivot_result.png

Webix pivot : http://devfree.byethost9.com/print_scr/webix_pivot.png

Webix result : http://devfree.byethost9.com/print_scr/webix_pivot_result.png

You can download the Excel file et test the datasource here : http://devfree.byethost9.com/print_scr/Datasource.xlsx

4

I’ve sent you PM.