Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Returns the sum of the numbers in list above i.e. 10 + 2 + 3 + 3.3 = 18.3

sumIf([10, 2, _NULL, 3.3])

Returns the sum of the numbers in list above and will ignore empty values i.e. 10 + 2 + 3.3 = 15.3

sumIf([10, 2, "a", 3.3])

Returns a type error as the value '"a' " is not a numeric value

sumIf(in.invoiceAmount)

...