2 Replies Latest reply: Jun 15, 2011 6:11 AM by Ania Domagala RSS

    Total or aggr not working like it should

      Hi

       

      I have done this before and it worked like a charm, but for some reason my expressions are not working like they should this time around.

       

      I created a band that seggregates the amounts into the various categories based on the year. These values were deflated to show a more realistic amount, and then categorized with the dimensions. Now, when I try to produce a percentage based on the column totals within the expressions it does not want to work.

       

      See Results below of what I am obtaining/ This happens for all the year. I've only shown for the one:

       

      2009
      Bandcount(RecordNumber)sum( TOTAL <Year> RecordNumber)aggr(sum(RecordNumber),Year)
      R0-R100K326326
      R101-R200K20962096
      R201-R300K2576257611964
      R301-R400K24782478
      R401-R500K15061506
      R501-R750K16841684
      R751K +12981298


      I would like to take the count(RecordNumber) and divide it by the total of the row.

       

      Thanks