Formulas are the expressions according to which the value of a Custom Measure is calculated.

 

The formal syntax for a formula is:

 <Formula> ::= <Num. Exp.> | (<Num. Exp.>)  | <Num. Exp.> [<Arith. Operator> <Num. Exp.>]

<Num. Exp.> ::= <Num. Function> | <Num. Literal> | <Measure> | <Measured Value>

<Arith. Operator> ::= + | - | \ | *

<Num. Function> ::= SUM | AVG | MIN | MAX | COUNT | COUNTDUP | ...

<Measured Value> ::= (<Measure>,<Scope>[, <Scope>...])

<Scope> ::= <Member> | <Group> | <Filter>

<Num. Literal> ::= A valid floating point or integer value.

See Also