2 Replies Latest reply: Jun 23, 2011 9:51 AM by Fernando Araujo RSS

    aggr () problem

      hi,

        I have a problem with a field of "goal" that when placed in a simple table with selections of months, customer, product and branch, for example returns 84000.

      But when I put him in a graph using a function sum () for the sum of all the months it returns in January ONLY 82908000 (84 000 would be right) the sum of all months is astronomical.

      I am using this formula in the graphs:

      sum (AGGR (BUDGET, Tax ID, BRANCH, PRODUCT, MONTH, YEAR, COMPANY))

      I believe that the AGGR play the role of dimensions for the sums.

      anyone have any idea why this happens

      Thank you

        • aggr () problem
          Johannes Sunden

          Sounds like you might have issues with your data model. Tables that are not connected and calculating something across those tables?

          Impossible to say for sure without looking at the document

            • aggr () problem

              It seems that the data model is not wrong, because when I search for tables and lists can reach values in the spreadsheets of the data source.
              The fact is that I get a function q I want to return a sum within
              I do not know how can I pass the file to give you a look because the data is confidential UMSA company.
              the budget spreadsheet data has the following dimensions
              COMPANY
              PRODUCT
              CUSTOMER
              BRANCH
              MES
              Based on these dimensions I think that a function always return to it would be summarized BUDGET oo "sum (AGGR (BUDGET, THE COMPANY, PRODUCT, CUSTOMER, BRANCH, MES))"
              I am sure this thought?