Why is Grand Total not matching with the Line Items?

Why is Grand Total not matching with the Line Items?

The Grand Total does not match with the Line items if all these are computed measures and the ‘Total’ cell for these measures displays the computed value but not the summed up value.

    • Related Articles

    • The total of the sub-level items do not match. Why?

      If there is an expression on measures defined in the KPI then, in order to satisfy the expression, the totals of the sub-level items in case of a drill-down KPI might not match. Discuss with support team for more information.

    • Reporting Line - New Feature

      According to the ARC Functionality only one level of node can be expanded in the KPI Grid. It is not possible expanding the node till the last level, because onclick of every parent node only the next level child nodes object (XML) gets constructed ...

    • Explain about the Reporting Line in Finance Analytics.

      According to the ARC Functionality only one level of node can be expanded in the KPI Grid, It is not possible expanding the node till the last level, because on click of every parent node only the next level child nodes object (XML) gets constructed ...

    • Why cannot I select items in Custom Reports?

      This problem can occur if there are extra trailing white space characters in the 'Desc' field of a DIM table, the description field in filter pop up shows multiple records for the same sub category as these descriptions are showing after ...

    • Line graph displays the error, 'Query Execution Failed ! :Ambiguous column name 'DATE_KEY'. Why?

      This error occurs if the column name is not defined properly. Illustration: --------------- The 'orderByDes' attribute - "DATE_KEY" might not be enclosed within '#' i.e. It should be defined as '#DATE_KEY#' For all the Dimension levels (For e.g. ...