# TOTAL

`TOTAL(SUM([Price]))`

## Syntax

TOTAL({aggregation method}(numerical expression))

Calculates value across the whole dataset for a given aggregation with numerical expression.

aggregation method: Any aggregation function `SUM`, `MAX`, `COUNT` and etc applied to numeric expression.

numerical expression: Basic arithmetic calculation created using the math operators `+, -, *, /`, numerical data fields and constants.

For example we have the data set below after applying aggregation `COUNT([ID])` to income record set

#`COUNT([ID])`
15
235
325

Applying `TOTAL(COUNT([ID]))` will give the table below

#`TOTAL(COUNT([ID]))`
15 + 35 + 25 = 65
25 + 35 + 25 = 65
35 + 35 + 25 = 65

## Spent Time Cumulative

Shows the cumulative tasks spent time over date and shows the total spent time line.

#### Source: `Tasks`

Time tracking stats for tasks of the building super hero suit

03 Jan 2018 10:13 AMCreate a steel helmet to protect head19Protective Suit
20 Jan 2018 04:08 PMCreate a chest protection from steel45Protective Suit
05 Feb 2018 11:34 AMAsk agency to create fancy identity for new super hero30Design
09 Feb 2018 02:11 PMInstall super hero logo on body and helmet2Protective Suit
09 Feb 2018 02:11 PMPut on gloves with nice color2Protective Suit
01 Mar 2018 06:45 PMAsk Hulk to push in chest5Combat Testing

### Chart `LINE`

#### Y: `TOTAL(SUM([Hours Spent]))``RUNNING_SUM(SUM([Hours Spent]))` DAY(Completed On)Value yCategory y
3 Jan 2018108TOTAL(SUM(Hours Spent))
3 Jan 201819RUNNING_SUM(SUM(Hours Spent))
20 Jan 2018108TOTAL(SUM(Hours Spent))
20 Jan 201864RUNNING_SUM(SUM(Hours Spent))
5 Feb 2018108TOTAL(SUM(Hours Spent))
5 Feb 201894RUNNING_SUM(SUM(Hours Spent))
9 Feb 2018108TOTAL(SUM(Hours Spent))
9 Feb 201898RUNNING_SUM(SUM(Hours Spent))
12 Feb 2018108TOTAL(SUM(Hours Spent))
12 Feb 2018103RUNNING_SUM(SUM(Hours Spent))
1 Mar 2018108TOTAL(SUM(Hours Spent))
1 Mar 2018108RUNNING_SUM(SUM(Hours Spent))