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 |
|
Latha27
Starting Member
20 Posts |
 Posted - 2012-03-15 : 17:42:59
|
| How do i fix the % Error into 0%I have this Total Sales Sales 1 Sales %$14,027.07 $7638.33 54%$0 $0 #Error$6,788.00 $339.40 5%Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-03-15 : 17:49:19
|
In your division, use NULLIF function.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
% Error