@REMAINDER

The @REMAINDER calculation function for Essbase returns the remainder value of an expression.

Syntax

This function returns the remainder value of expression.

@REMAINDER (expression)

Parameters

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