Yandex Cloud
Search
Contact UsGet started
  • Blog
  • Pricing
  • Documentation
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • Containers
    • Developer tools
    • Serverless
    • Security
    • Monitoring & Resources
    • ML & AI
    • Business tools
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Customer Stories
    • Cloud credits to scale your IT product
    • Gateway to Russia
    • Cloud for Startups
    • Education and Science
    • Yandex Cloud Partner program
  • Blog
  • Pricing
  • Documentation
© 2025 Direct Cursus Technology L.L.C.
Yandex DataLens
    • Overview
    • Formula syntax
      • All Functions
        • Overview
        • AVG
        • AVG_IF
        • COUNT
        • COUNT_IF
        • FIRST
        • LAG
        • LAST
        • MAVG
        • MAX
        • MCOUNT
        • MIN
        • MMAX
        • MMIN
        • MSUM
        • RANK
        • RANK_DENSE
        • RANK_PERCENTILE
        • RANK_UNIQUE
        • RAVG
        • RCOUNT
        • RMAX
        • RMIN
        • RSUM
        • SUM
        • SUM_IF
      • Function Availability
    • Parameters
  • Audit Trails events
  1. Calculated fields
  2. Function reference
  3. Window functions
  4. SUM

SUM (window)

Written by
Yandex Cloud
Updated at November 6, 2024

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

SyntaxSyntax

Standard
Extended
SUM( value
     TOTAL | WITHIN ... | AMONG ...
   )

More info:

  • TOTAL, WITHIN, AMONG
SUM( value
     TOTAL | WITHIN ... | AMONG ...
     [ BEFORE FILTER BY ... ]
   )

More info:

  • TOTAL, WITHIN, AMONG
  • BEFORE FILTER BY

DescriptionDescription

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)

ExampleExample

Source data

Date City Category Orders Profit
'2019-03-01' 'London' 'Office Supplies' 8 120.80
'2019-03-04' 'London' 'Office Supplies' 2 100.00
'2019-03-05' 'London' 'Furniture' 1 750.00
'2019-03-02' 'Moscow' 'Furniture' 2 1250.50
'2019-03-03' 'Moscow' 'Office Supplies' 4 85.00
'2019-03-01' 'San Francisco' 'Office Supplies' 23 723.00
'2019-03-01' 'San Francisco' 'Furniture' 1 1000.00
'2019-03-03' 'San Francisco' 'Furniture' 4 4000.00
'2019-03-02' 'Detroit' 'Furniture' 5 3700.00
'2019-03-04' 'Detroit' 'Office Supplies' 25 1200.00
'2019-03-04' 'Detroit' 'Furniture' 2 3500.00

Grouped by [City], [Category].

Sorted by [City], [Category].

Formulas:

  • City: [City] ;
  • Category: [Category] ;
  • Order Sum: SUM([Orders]) ;
  • SUM TOTAL: SUM(SUM([Orders]) TOTAL) ;
  • SUM WITHIN: SUM(SUM([Orders]) WITHIN [City]) ;
  • SUM AMONG: SUM(SUM([Orders]) AMONG [City]) .

Result

City Category Order Sum SUM TOTAL SUM WITHIN SUM AMONG
'Detroit' 'Furniture' 7 77 32 15
'Detroit' 'Office Supplies' 25 77 32 62
'London' 'Furniture' 1 77 11 15
'London' 'Office Supplies' 10 77 11 62
'Moscow' 'Furniture' 2 77 6 15
'Moscow' 'Office Supplies' 4 77 6 62
'San Francisco' 'Furniture' 5 77 28 15
'San Francisco' 'Office Supplies' 23 77 28 62

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Yandex Documents.

Was the article helpful?

Previous
RSUM
Next
SUM_IF
© 2025 Direct Cursus Technology L.L.C.