Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tmcivery
Starting Member
46 Posts |
 Posted - 2008-08-07 : 12:43:57
|
| Hey everyone,Please forgive me for what is probably a simple question but I've been thrown into the fire and it's getting hot.I'm creating a table report that requires me to list all tickets for a date range and then give a percentage of those tickets that have a status(field name is StatusEnglish) of closed. My problem is creating an expression which gives me this percentage. I have a demo database that has 8 tickets in which 2 are closed so I should be seeing 25% as closed but I cannot seem to get to this number. Any direction would be helpful. |
|
|
tmcivery
Starting Member
46 Posts |
Posted - 2008-08-07 : 13:06:40
|
| I figured it out folks. No reason to reply. |
 |
|
|
|
|
|
Newbie Question