Notifications

79 views

Symptoms


Multi-level pivot table reports can show incorrect total count values when aggregating based on a Count Distinct and a Reference field.

Release


All Releases

Cause


This can occur when the aggregation is based on a Count Distinct and a Reference field as the platform applies the Count Distinct on the Reference field's display value. If there are multiple records for the Reference field with the same Display value, the aggregated count will then show a smaller number than the actual count of distinct records.

Resolution


Modify the Display values of the Reference field so that they are unique.

Article Information

Last Updated:2018-09-12 23:41:11
Published:2018-09-13