count and percentage.. is it possible (1 Viewer)

[doran_doran]

1. I have a Total Query by category
2. I have a report using the same query so I can put the category on the 1st column and the total on the second column.
3. I would like to see % on the third column on my report.

How do I achieve that? I tried everything...

See my sample from Excel....

Category Total Percentage
401(a) 5 13.51%
401(k) 17 45.95%
401(b) 15 40.54%
Total 37 100.00%

 

[dcx693]

It's been a while since I've done this, but you should easily be able to create totals on your reports by using the Sum function in the report footer. Then just create text boxes where the % calculations occur. If the call the sum of the Totals column [SumTotal], then use something like [Total]/[SumTotal].

 

[doran_doran]

tried that...

Thanks for the prompt respond.

I tried that and it did not work. It throws my number of the count.

 

[cpuSmoker]

It throws my numbers off the count

Download this example enclosed.
If you want to export this information to excel in another format, IE the table you posted earlier, why I don't know, that's what the report builder is for, anyway, you may have to write the vb routine to gather the information and post it to a buffer table in the format that can you want and can then be exported to excel using the transferspreadsheet function.

If you need help with this, some sample data needs to be enclosed and an example of the format you expect to see in excel should also be provided.