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

• Related Articles

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

  The Total row of an expression measure will provide the summation of all the rows whereas, computed measure will provide results based on the formula specified. This is the 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 ...

• How can I display the measure in thousands or millions?

  Use the KPI Utility 'Unit Measure' to set the required units. This feature is session based and applicable only for currency type measures.

• Can an Expression Measure be added to a Computed Measure?

  As per product functionality, you cannot add expression measures into a computed measure since computed measure are generated run time & being created by ARC once data has been fetched from database.

• Where do we use an Expression Measure?

  Expression measure can be used where a conditional statement (for example, IF-THEN-ELSE) is necessary. You can use a base measure or a computed measure within an expression measure. An expression measure cannot be used within an expression measure.