The following are common errors:
Enclose all functions, such as mResult, in brackets. A formula must have a set of each colored bracket.
This is incorrect: Average(mresult “measurename”).This is correct: Average(mResult(”Measure”)).
Enclose the name of any object you use in a measure, in quotation marks.
This is incorrect: MIN(onScorecardMeasures) score,Revenue)).This is correct: MIN(onScorecardMeasures) score,“Revenue”)).
Enclose the name of all dimensional measures that you use in a formula in square brackets.
This is incorrect: MAX(dimensionalMeasure (result, “Revenue”, [“Venice, “Products”)This is correct: MAX(dimensionalMeasure (result, “Revenue”, [“Venice”, “Products”]).
Do not place quotation marks around this. This:“this” is incorrect.