Formula Syntax and Terminology
Formulas take the general form:
[Note the semicolon (;) that completes the expression.]
Where

DESCRIPTION 
LHS 
Lefthand side range, for the data to be calculated by the formula (i.e., where data will appear in the Cube); 
RHS 
Righthand side, which will either be a constant or a calculation performed on data from the range of a specified originating Cube (may be the same Cube). 
Notes
as will be demonstrated, the LHS can be constructed using the Build Range Reference dialog box; and the RHS can be constructed, using the Build Cube Reference dialog box.
A Numeric Formula is any valid arithmetic expression composed of one or more of the items in the table:

Example 
Numeric Constants 
e.g.: 2, 3.5, 2.5E10, etc. 
Numeric Operators 
e.g.: +, , *, / 
Parentheses 
( ) 
Specific Functions 
e.g.: round, abs(x), IF, etc… 
Numeric Constants are the simplest components of a numeric formula. A numeric constant consists of digits, an optional leading sign, and an optional decimal point.

Example 
Valid Numeric Constants 
6 2 5.0 
Invalid Numeric Constants 
0a 0 3..0 
Numeric Operators are simple mathematical expressions:

Operator 
Addition 
+ 
Subtraction 
– 
Multiplication 
* 
Division 
/ 
Exponentiation 
^ 
If different numeric operators are used in an expression, the order of computation is:
1st: 
Exponentation 
2nd: 
Multiplication and Division 
3rd: 
Addition and Subtraction 
Parentheses may be used to force a different order of computation and are used in traditional algebraic notation. For example, 2*3+4 is the same as (2*3)+4 which equals 10. Whereas, 2*(3+4) equals 14.
Specific Functions are provided by PowerOLAP^{®} for additional computation capabilities. They have a wide variety of uses from simple sums to trigonometric and financial functions to logical constructions (an example of a logical function, an IF statement to be discussed inCube Formulas topic of this section). All are described in the section Advanced Reference Materials.
Notes
The full range of PowerOLAP Cube Formula Functions is explained in detail in the section for Advanced Reference Materials.