Views calc distinct

Component ID

2284889

Component name

Views calc distinct

Component type

module

Maintenance status

Development status

Component security advisory coverage

covered

Downloads

1803

Component created

Component changed

Component body

Views calc doesn't calculate correct values if used in a view with one ore more relationships that will create multiple rows in the result which are limited by a distinct setting. If the query is set to "distinct" the calculation will add the total calculation of all queries even for rows that are hidden by the distinct statement. This behaviour in general is correct from a queryie's point of view but it will not match the customer's expectation.
Therefore this module is made. You can install it and it will correct all views calc displays out of the box. Also for fine grained control you can choose the "views calc distinct" display in a view and set the option "Enable Views Calc Distinct". This will correct the calculation of results with a distinct query for a specific view.

This module was developed for correct calculations in the ERPAL for Service Providers distribution