Solved

Getting a Percent from a returned row of data

Posted on 2008-06-17
1
578 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Select in Access 2003 3 43
How to keep a record with the highest value 3 44
SP result not being displayed 5 47
SQL query 7 23
In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
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…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

697 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