Databases Reference
In-Depth Information
Math
In addition to the operators previously described, Essbase has provided you with
a comprehensive set of functions used to perform mathematical calculations in your
database calc script. These functions return values to the calculation data based upon
the specific mathematical function you have chosen. Some of the more widely used
mathematical functions are
@SUM()
,
@AVERAGE()
, and
@VAR()
.
•
@SUM()
: This function is used to return the sum of the members in the
comma separated member list or the sum of the members returned from
a member function.
@SUM("CHICAGO","DETROIT");
This means the sum of CHICAGO + DETROIT
.
For more information, refer to the online technical reference included
with your EAS software.
•
@VAR()
: This function returns the variance (difference) between the two
members listed as parameters. The variance is calculated by subtracting
the first member from the second member.
@VAR(ACTUAL,BUDGET);
•
@VARPER()
: This function is used to return the percent variance (percent
difference) between the two members listed. The percent values are
calculated by dividing the first member by the second member.
@VARPER(ACTUAL,BUDGET);
•
@ROUND()
: This function will round the value of the
expression
parameter to
the number specified by the
NUMDIGITS
parameter to the right of the decimal.
@ROUND(EXPRESSION, NUMDIGITS)
@ROUND(SALES,2)
If the Sales value = 1000.926, then after rounding, it would be 1000.93.
Member set
Member set functions typically return a list of database outline members. Depending
on the function you have selected for use, it can dynamically generate a list of
members that are needed in the calculation. Member set functions are widely used
in conjunction with the
FIX()
statement to help specify a list of outline members
for calculation.
