Getting Total Percentages

• Chuck Snyder

  SSC-Addicted

  Points: 458

  More actions

  November 25, 2005 at 10:13 am

  #364326

  I've got a table with a Header section, a Group Level 1 and the body.

  At the body level I need the Percent of an asset that is held.....

  Header: Asset - 10,000

  Group: Asset - 600

  Body: Asset 100     16.66%

           Asset 200    33.33%

           Asset 300    50.00%

  I can get the Total of the Header/body but need the group level1 total to do the percent calculation.

  Thanks

  Chuck

• November 28, 2005 at 8:00 am

  This was removed by the editor as SPAM

• ofir shoval

  Ten Centuries

  Points: 1278

  More actions

  November 29, 2005 at 2:07 am

  #606336

  Use aggregate function like sum,avg is the next format:

  SUM(Field!asset,"GroupName") that will do the work...

• Chuck Snyder

  SSC-Addicted

  Points: 458

  More actions

  November 29, 2005 at 8:48 am

  #606436

  Thanks.  That is what I was looking for.  Couldn't find it in the docs.