avg calculated incorrectly

[AlexBlocked]

Aggregate function avg calculated is not correctly! calc empty cell.

and min sometimes, when first row have empty cell show 0.

[ivailoParticipant]

Hi Alex,

This is correct behavior. When you calculate numbers, empty cells are equalized to 0.
If you want to make average only with cells with values, you can filter empty cells and the result will be as you expected.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[AlexBlocked]

Other functions ignore empty cells.
0 is a real value and an empty value just empty it is not stored in the database.
You made a big mistake that mixed 0 and empty value.
I wait when you will fix it, otherwise the package is not worth nothing.

[ivailoParticipant]

Hi Alex,

If you want another behavior you can create your own aggregate function.
Here is a demo with custom aggregates.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[AlexBlocked]

I want to bug would be fixed and not declared as the norm.
I have not heard, this bug will be fixed?

[Peter StoevKeymaster]

Hi Alex,

Due to the not polite and not professional behavior in our Forum, according to our Forum policy, your account is blocked from now.

Regarding the current situation in this topic: The behavior is not a bug and we consider it to be correct behavior.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts