Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

Excerpt

Returns the value of summing the first argument and the second argument. Equivalent to the + operator.

  • Each argument can be a literal Integer or Decimal number, a function returning a number, or a reference to a column containing numeric values.
Info

NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Numeric Operators.

 

D s
snippetBasic

D code

derive type:single value: ADD(2,3) as:'five'

Output: Sums the values 2 and 3 and stores the value in a new column called five

D s
snippetSyntax

D code

derive type:single value:ADD(value1, value2)

ArgumentRequired?Data TypeDescription
value1YstringThe first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types.
value2YstringThe first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types.

D s lang notes

value1, value2

Integer or Decimal expressions, column references or literals to sum together.

  • Missing or mismatched values generate missing string results. 

D s
snippetusage

Required?Data TypeExample Value
YesLiteral, function, or column reference returning an Integer or Decimal valuemyScore * 10

D s
snippetExamples

Example - Numeric Functions

Include Page
EXAMPLE - Numeric Functions
EXAMPLE - Numeric Functions

D s also
labelmath