You are right. It worked once I fixed the totalling on the varable. I was totalling twice.

bob


>>I have a report that totals a group of 7 amounts across the report, then sums all the totals at the bottom. 6 columns total to a category total and the 7th column is a misc. "other". The SQL query that creates the data also creates a "total" column that adds all 7 columns into a total. So I have Colunm1+Column2 + Other etc. = Total. Which when I review the query result it correctly adds all the columns correctly.
>>
>>What I am trying to do is determine the percent of the total that represents Other/Total at the end of the report. The problem is the percent will not calculate properly for some reason.
>>
>>I thought maybe what I needed to do was create a variable summing the Other column and also another variable summing the Total column and then take result of these variablesof divide: ie.. other_total / grand_total = (the Percent i'm looking for). But again the division doesn't seem to work to give the correct percentage.
>>
>>Does anyone know what I might be doing wrong? BTW, the above calculation is occuring in a summary band.
>>
>>Bob Bartel
>
>Hi Bob,
>
>Using variables approach should work. Did you verify that you didn't sum twice or something like this? Put the variables close together along with the percentage.
>
>Do you use Print When condition in your details? Where did you put to reset these variables?