3 Replies Latest reply: Feb 5, 2015 8:24 AM by Gysbert Wassenaar RSS

    troubles with a double aggr function

      dear all,

       

      I'm having some trouble with my aggr.

      I'm trying to get per line its share in the CategorieSubgroep.... For some reason 1 line per subcategorie is working bu the others are not showing. They are based on the subtotal of the subcategorie.

       

      Aandeel2 should be filled for all lines. --> shown answers are correct sofar, now for al.

       

      appreciate the help!!

       

      regards

      Aggr issue.JPG

      Sum({$<
      table_code={2},
      Revenue={'MAT'}
      >}
      afzet)
      /
      Sum(
      aggr(sum(
      {$<
      table_code={2},
      Revenue={'MAT'}
      >}
      afzet), CategorieSubGroep_Subgroep_omschrijving))