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 |
|
huynhtl
Posting Yak Master
107 Posts |
 Posted - 2008-07-07 : 20:05:01
|
| Hi,I'm having problem with dividing by zero error.I'm trying to divide grandtotal by total. Some total are zero.Here is the code that I usediif(sum(fields!g_total.value,"grandtotal")/fields!total.value =0,0,fields!g_total.value/fields!total.valueI have grandtotal as one dataset and total as another.Please help!!!!!!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-08 : 06:49:47
|
| will be something like this:-iif(fields!total.value =0,0,fields!g_total.value/fields!total.value)didnt understand your expression though...1 place you're using sum and dataset name but inside you've not used it. |
 |
|
|
huynhtl
Posting Yak Master
107 Posts |
Posted - 2008-07-08 : 15:37:37
|
| Thanks, I've figure out what I did wrong. |
|
|
|
|
|
|
Divided by zero error