Solved

Getting a Percent from a returned row of data

Posted on 2008-06-17
1
576 Views
Last Modified: 2008-06-17
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.

Thanks
0
Comment
Question by:David2112
1 Comment
 

Accepted Solution

by:
David2112 earned 0 total points
ID: 21806945
Ok,

Here's what I did.
Thankfully, I had to put this into an Excel spreadsheet, so
I just got the percentages from an additional query and did a COUNTIF to get the percentage based on the month.

0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question