Total SQL Function

The Total() function is an aggregate function which takes one (1) argument and returns the sum of all non-null values, if there are no non-null values then it will return 0.0 as it's result is always floating point number which is REAL datatype in the library.

Syntax Total( ColumnName )

/* Following will return floating-point number */ 
SELECT Total(OrderAmount);