|
-
Jun 7th, 2006, 09:32 AM
#1
Thread Starter
Fanatic Member
Grade 3 Math Question
I'm embarassed that I have to ask this, but here goes...
I have a report that displays a summary of totals in two columns.
One of the columns is this years YTD total, and the other column is last years YTD total.
For example, this year there were 714 people, last year there were 901 people. That means the percent decrease was -20.75% correct? Okay.
So what do you do when last years total was zero. Let's say for example last year was 0, and this year it's 14. What should I display in the "% Diff" column for that!! Excel gives me a #DIV/0 as it should, but there has to be a percent difference doesn't there, because there IS a difference!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|