KNOWLEDGE BASE

Error "Argument to sum ... is already an aggregation" Creating Calculated Field


Published: 18 Jun 2014
Last Modified Date: 08 May 2017

Issue

When you try to create a calculated field in Tableau Desktop, the following error might occur:
 
Argument to sum (an aggregate function) is already an aggregation, and cannot be further aggregated.

Environment

Tableau Desktop

Resolution

In the calculated field formula, remove the SUM() function with the red underline.

Cause

The value in the calculated field being summed is already aggregated. It is not possible to aggregate a field more than once.
Did this article resolve the issue?