MakeCalc()
Use MakeCalc() to build a string that can be used to calculate a member value in MDX.
If you want to use calculations in your MDX, you can use MakeCalc() to build a string that can be used in MDX. MakeCalc() takes an input of a member ID and an expression and outputs an MDX compatible string.
Syntax
MakeCalc(<member ID>, <expression>)|
Argument |
Description |
Required/Optional |
|---|---|---|
|
Member ID |
The member ID of the member that you want to calculate a value for. |
Required |
| Expression |
The calculation expression that you want to use. |
Required |