MDX format for power(raise to) in custom calculation
Summary:
Hi All,
I want to build below formula,
[Adjustment]:=([input][account])*(1+([input][mark up]))^3
- What is the format for MDX format for power function (raise to) in custom calculation?
From the documents, I got below format and tried with just numbers and dimension members, but both are giving error "Missing resource: com.essbase.api.base.EssException: Cannot Perform Custom Calc. Essbase Error(1300056): The expression is invalid"
Syntax: Power ( numeric_value_expression, power )
Power(9, 2.5)
returns 243
- How to give power value also a dimension member?
[Adjustment]:=([input][account])*(1+([input][mark up]))^([input],[dynamic power factor]);
Content (required):
Version (include the version you are using, if applicable):
Tagged:
0