$total

$total

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

$total

Sums a set of values, excluding those in which the expression is $Null.

Syntax

$total(expression)

Parameters

expressionany expression

Return Value

Number.

Comments

Expression is often a WHERE expression that includes only selected values in the totalling operation. If the WHERE expression (expr1 WHERE expr2) is true, the expr1 value is included in the operation; otherwise, expression is considered $Null and is not included.

Example

compute Employees where DeptName="Sales"
evaluate(let TotSal = $total(Salary))
(let TotSalF = $total(Salary where Sex = "F"))

Finds the total of all employees’ salaries, and the total of the salaries of all female employees, in the Sales department.

See Also

$average

$count

$max

$min

About Functional Expressions

Number Literals

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

pt_BRPortuguese