Percent of Total? How can I do?

[2004 IR Help]

By: Andrew McLaughlin - pik0

Percent of Total? How can I do?

2004-08-17 17:10

Okay, this is kickin my butt! I have a report is working great except for one column. There is an auction results page and it includes an Awarded Price column with a column total at the bottom.

 

The last column needs to be a percent. Not just any percent, mind you, it need to be a percent that the Awarded Price is of the total Awarded Price at the end of the report.

 

I've played with using a subreport having it run a query that gets the sum of that Awarded_Price column, but I can't figure out how to get the result back to do the calculation.

 

Anyone else accomplish something like this yet?

 

Piko