Solved

Getting a Percent from a returned row of data

Posted on 2008-06-17
1
579 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

707 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