I need to get a percentage of a number I am returning from a query, such as
My current returned columns are:
Year count(acct type > 1) % of acct type count with something > 1000
2000 122 10%
2001 85 32%
I can get the year and count of acct type, but I'm not sure how to get the % of that for the next column.
I'm guessing I need a variable for the count(acct Type > 1).
Any help is appreciated.