Calculated Field Returning Incorrect Results
Published: 28 Mar 2013
Last Modified Date: 18 Apr 2018
IssueA calculated field is returning incorrect results. For example, a field with the formula:
is not returning the expected ratio.
- Aggregate the measures within the calculated field. For example, change the calculated field's formula:
- Remove the calculated field from the view and then re-add it to the view.
CauseThe calculation used the disaggregated (row) values instead of the aggregated (summed) values of the fields.