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

AND

Returns true if both arguments are logically true, and returns false if either of the arguments are logically false.

The And function takes in two arguments and both are required. To evaluate more than two logical expressions at a time, you can nest multiple And functions (see examples below).

Syntax: AND (logical_expression_1,logical_expression_2)

  • logical_expression_1 is the first logical test or expression or boolean value (true, false)

  • logical_expression_2 is the second logical test or expression or boolean value (true, false)

Example: AND ( true , true ) Output: true

Example: IF ( AND ( AND ( 1 < 2 , 2 < 3 ) , 1 == 1 ) , 8 , 9 ) Output: 8

PreviousABSNextAVERAGE

Last updated 6 months ago

Was this helpful?