Drivetrain Knowledge Hub
  • Getting started
    • Start here
      • Navigating Drivetrain
      • Key terms & concepts
    • Reports
      • Interacting with reports
      • Creating a report
      • Collaborating on a report
    • Data
      • Connecting data sources
      • Explore your datasets
      • Transforming and enriching data
    • Metrics
      • Metric Builder overview
      • Creating a metric from a dataset
      • Creating a metric using formula
      • Adding dimensions
    • Models
  • Modeling
    • Models page overview
    • Creating a model
    • Formatting a variable
    • Adding plan/forecast numbers to a variable
    • Lists overview
    • Adding dimensions to a model
    • Saving and managing versions
    • Creating and comparing scenarios
    • Setting up reconciliation workflows
    • Collaborating on models (commenting)
    • More model elements
    • Practical example
  • Formulas
    • Formulas in Drivetrain
      • Referencing metrics in formulas
      • Operators
      • Functions
        • ABS
        • AND
        • AVERAGE
        • BLANK
        • BOMONTH
        • CEIL
        • COLLAPSE
        • CONCAT
        • DATE
        • DATEADD
        • DATEDIFF
        • DATEVALUE
        • DAY
        • DAYSINMONTH
        • EOMONTH
        • EQUALS (or EQ)
        • EVEN
        • FINANCIALYEARSTARTMONTH
        • FLOOR
        • FORECAST
        • IF
        • ISBLANK
        • LAST ACTUALS DATE
        • LOOKUP
        • LOWER
        • MAX
        • MID
        • MIN
        • MOD
        • MONTH
        • NETWORKDAYS
        • NOT
        • ODD
        • OR
        • PERIOD
        • PRORATA
        • QUARTERTODATE
        • ROUND
        • ROUNDDOWN
        • ROUNDUP
        • SLN
        • SUM
        • SUMMARIZE
        • THIS MONTH
        • TODAY
        • VALUE
        • UPPER
        • YEAR
        • YEARTODATE
  • User Administration and Access
    • Access control & permissions
      • Creating a user
      • Creating and managing roles
      • Understanding permissions in roles
      • Reviewing user permissions
    • Data masking
  • Data Governance
    • How Drivetrain ensures data quality
  • Integration guide
    • Integrate with Drivetrain
  • 📡Extending Drivetrain
    • Drivetrain API
      • Get metric list API
      • Get metric data API
    • Export to data warehouses
      • Export to BigQuery
    • Google Sheets add-on
    • Integration for Slack
Powered by GitBook
On this page

Was this helpful?

  1. Formulas
  2. Formulas in Drivetrain
  3. Functions

SLN

PreviousROUNDUPNextSUM

Last updated 4 months ago

Was this helpful?

Calculates the depreciation of an asset using the straight-line method.

Syntax: SLN (cost,salvage,life ,start_date)

  • cost is the initial value of the asset purchased

  • salvage is the value of the asset at the end of its useful life (i.e, end of the depreciation period)

  • life is the life of the asset in years

  • start_date (optional) indicating the beginning of the depreciation calculation. If not provided, it'll default to the plan start date

Example: SLN ( 100000 , 5000 , 5 , DATE ( 2024 , 02 , 01 ) )

Output: