Post reply

Getting Total Percentages

  • 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

  • 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...

  • November 29, 2005 at 8:48 am

    #606436

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply