>>This is a classic problem, with a classic solution: you just can´t do it with variables. You need to calculate, *before* you list anything, the grand total, so it will be available for calculating percentages.
>>
>>HTH!
>
>Thanks for the reply, Federico
>
>Sorry about the rookie type questions but if I calculate the percentage values before I run my report, how do I pass the values to my report before it runs.... with the 'with' command like I do in a procedure as in do 'something' with perc1,perc2,perc3 etc. ?
>
>thanks for your time !
>
>Don
Don, a "Cheezy" solution (quick but not elegant) is to calculate the total values you need into a separate cursor with 1 record. Or, in this case, just the final sum. Then in your report, you calculate your percentages using the group total/pre-calculated value. The cursor will be available just like the table/cursor you are using for report data.
HTH
Barbara