MDX format for power(raise to) in custom calculation
I want to build below formula,
- 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
- How to give power value also a dimension member?
[Adjustment]:=([input][account])*(1+([input][mark up]))^([input],[dynamic power factor]);
Version (include the version you are using, if applicable):