There is a formula defined for the column, earlier version there is no issues when using the field which is not in the data list. But since 2.7.11 I am getting the error as attached. Please check and let know the feasible solution.
Thank you for the question.
In case you need to disable the warning, please use a special option
Here is the sample: https://jsfiddle.net/flexmonster/wsjy05n7/
Please note, that the results of formulas with non-existing fields may be unexpected. We strongly recommend excluding such formulas from the reports (and the warning message can help to identify such formulas).
Hope you find this helpful.
I ran into the same problem and it seems some characters are not allowed for the uniqueName attribute anymore. We use [Measures].[MEASURENAMEHERE] format for all measures and it works fine with 2.3 version but not with 2.7 (latest). For example,
formula – “formula”: “\”[Measures].[AdvertiserSpendInMD]\” / (1000 * \”[Measures].[Volume]\”)“
Note, you can easily reproduce it with this example https://jsfiddle.net/flexmonster/x0pe8azg/. Just rename “Price” measure to “[Price]” both in the measure definition and formula.
I’m going to add “validateFormulas”: false but it seems like a bug to me.
Thank you for pointing this out to us.
The described behavior is not the expected one: brackets should be allowed in
Our team will research this issue in more detail and we will notify you about the results with the ETA 2nd of December.
As a temporary solution, we kindly advise disabling the validation pop-up.
Please feel free to write to us in case further questions arise.