Yandex Cloud
Documentation
PresentationContact UsTry it for free
© 2026 Direct Cursus Technology L.L.C.
Yandex DataLens
    • Overview
    • Formula syntax
    • Neuroanalyst for creating calculated fields
      • All Functions
        • Overview
        • ABS
        • ACOS
        • ASIN
        • ATAN
        • ATAN2
        • CEILING
        • COMPARE
        • COS
        • COT
        • DEGREES
        • DIV
        • DIV_SAFE
        • EXP
        • FDIV_SAFE
        • FLOOR
        • GREATEST
        • LEAST
        • LN
        • LOG
        • LOG10
        • PI
        • POWER
        • RADIANS
        • ROUND
        • SIGN
        • SIN
        • SQRT
        • SQUARE
        • TAN
      • Function Availability
    • Parameters
  • DataLens Gallery
  • Audit Trails events
  1. Calculated fields
  2. Function reference
  3. Mathematical functions
  4. FDIV_SAFE

FDIV_SAFE

Written by
Yandex Cloud
Updated at December 19, 2025
View in Markdown

SyntaxSyntax

FDIV_SAFE( numerator, denominator [ , fallback_value ] )

DescriptionDescription

Divides numerator by denominator. Returns fallback_value if division by zero occurs. If the number fallback_value is omitted, it is assumed to be NULL.

Argument types:

  • numerator — Fractional number | Integer
  • denominator — Fractional number | Integer
  • fallback_value — Fractional number | Integer

Return type: Fractional number

ExampleExample

[numerator] [denominator] FDIV_SAFE([numerator], [denominator]) FDIV_SAFE([numerator], [denominator], 42)
5.00 2.00 2.50 2.50
5.00 0.00 NULL 42.00

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, Trino, Yandex Documents, YDB.

Was the article helpful?

Previous
EXP
Next
FLOOR
© 2026 Direct Cursus Technology L.L.C.