I am trying to figure out a method to calculate a percentage by each row.  Currently I have a formula that works correctly it is based on the display string in a cross tab.

numbervar z:=0;

z:=currentfieldvalue/(SUM({@TotalAboveIn}))*100;

totext(z,2)+"%";

 

however, I have different totals by row and would like the it to use the row total instead of the main one. 

Any idea?

 

Thanks,

Nick

 

Here is what the crosstab looks like:
         % Above | % Below | Total

1            40%       60%        3256

2                                          2800

3                                           450

 

I want to calculate %'s for each row by using the total that is on that row.

 

Thanks!