@REMAINDER

Returns the remainder value of expression.

Syntax

@REMAINDER (expression)
ParameterDescription

expression

Single member specification, variable name, or other numeric expression.

Example

Margin = @REMAINDER("Margin %");

This example produces the following report:

                          Product   Market 
                  Margin %                  Margin         
            Jan     Feb     Mar      Jan      Feb      Mar
            ===     ===     ===      ===      ===      === 
Scenario  55.10   55.39   55.27     0.10     0.39     0.27 

See Also

  • @TRUNCATE