Expression measure created shows the sum of all data displayed. It is expected to show based on the expression specified

• Related Articles

• Does the Expression Measure display the sum of all the data or data based on the expression specified?

  Expression Measure displays the sum of all the data. The Total Row of an Expression Measure displays the sum of all the rows. The Computed Measure for a KPI displays the data based on the expression specified. This is a standard ARC functionality.

• Why is the data displayed on Expression Measure, inconsistent?

  The data displayed on Expression Measure can be inconsistent if the data to be displayed contains decimal values. You have to alter the query in the computation of the expression. For example, the expression measure to compute the Inventory Turns ...

• While adding a base measure with average aggregation then, the total field should show the average value, but it shows the sum of that average. Why?

  Whenever the aggregate functions are applied, it will consider only the line items but not the TOTAL column. Total field always displays the summed-up values from the line items.

• Why do I get the error 'Measure not applicable', when I use the created expression measure in KPI?

  The reasons could be any of the following: Measure ID is not prefixed with Table Name. Expression is not correct. This error can also occur in newly created measures due to the following reasons: Measure is not created/defined properly. The character ...

• When I add a base measure with average aggregation, the Total field should show the average value. But why is it showing the sum of that average?

  The sum of the average is displayed in the 'Total' field becauase the functionality is to display the total value and not the average value. When you add a base measure with average aggregation, it considers only the line items and not the 'Total' ...