Essbase @REMAINDER

Returns the remainder value of expression.

Syntax

@REMAINDER (expression)
Parameter Description
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