Yandex Cloud
  • Services
  • Solutions
  • Why Yandex Cloud
  • Blog
  • Pricing
  • Documentation
  • Contact us
Get started
Language / Region
Yandex project
© 2023 Intertech Services AG
Yandex DataLens
  • Getting started
  • Tutorials
  • Concepts
  • Step-by-step guides
  • Access management
  • Pricing policy
  • Visualization reference
  • Function reference
    • All Functions
    • Aggregate functions
      • Overview
      • ALL_CONCAT
      • ANY
      • ARG_MAX
      • ARG_MIN
      • AVG
      • AVG_IF
      • COUNT
      • COUNTD
      • COUNTD_APPROX
      • COUNTD_IF
      • COUNT_IF
      • MAX
      • MEDIAN
      • MIN
      • QUANTILE
      • QUANTILE_APPROX
      • STDEV
      • STDEVP
      • SUM
      • SUM_IF
      • TOP_CONCAT
      • VAR
      • VARP
    • Array functions
    • Date/Time functions
    • Logical functions
    • Mathematical functions
    • Operators
    • String functions
    • Text markup functions
    • Time series functions
    • Type conversion functions
    • Window functions
    • Function Availability
  • Function tutorials
  • Courses
  • Troubleshooting
    • Questions and answers
    • DataLens errors
  1. Function reference
  2. Aggregate functions
  3. SUM

SUM

Written by
Yandex Cloud
,
improved by
amatol

Function SUM is also found in the following categories: Window functions.

Syntax

Standard
Extended
SUM( value )
SUM( value
     [ FIXED ... | INCLUDE ... | EXCLUDE ... ]
     [ BEFORE FILTER BY ... ]
   )

More info:

  • FIXED, INCLUDE, EXCLUDE
  • BEFORE FILTER BY

Description

Returns the sum of all expression values. Applicable to numeric data types only.

Argument types:

  • value — Fractional number | Integer

Return type: Same type as (value)

Example

Source data

City Category Orders Profit
'London' 'Office Supplies' 8 120.10
'London' 'Furniture' 1 750.00
'Moscow' 'Furniture' 2 1250.50
'Moscow' 'Office Supplies' 4 85.34
'San Francisco' 'Office Supplies' 23 723.00
'Detroit' 'Furniture' 5 6205.87

Grouped by [City].

Sorted by [City].

Result

[City] SUM([Orders]) SUM([Profit])
'Detroit' 5 6205.87
'London' 9 870.10
'Moscow' 6 1335.84
'San Francisco' 23 723.00

Data source support

ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, Oracle Database 12c (12.1), PostgreSQL 9.3, YDB.

Was the article helpful?

Language / Region
Yandex project
© 2023 Intertech Services AG