query to calculate percentages

[miconian]

So, I have three fields:

Revenue Under Goal (currency)
Site (text)
Order Line (number)

My goal is to answer this question:

By site, what percentage of the order lines have revenue under goal?

So the ideal results would looks something like this:

SiteA 20%
SiteB 43%

I admit that I'm really not even sure where to begin with this one. Any thoughts much appreciated. Thanks!

 

[miconian]

You're right, it works.

Right now I have it broken up into two separate queries, but I will work on combining them later.

Thank you very much!