I have a column that divides a field by another field. And if it is 0 I it prints Error. How can I get it to print nothing or a 0 in this situation?
+1
A:
Can you just create an expression for the result column and display the result conditionally?
Eg, instead of:
=ColumnA!Value/ColumnB!Value
Use something like:
=Iff(ColumnB!Value <> 0, ColumnA!Value/ColumnB!Value, 0)
Stefan Mohr
2010-03-05 20:51:25