divide by zero/null workaround in SSRS 2008 report

by

Jamie F’s answer is correct. As a tip, you can add a function to your report code to make the division a bit easier to implement in multiple cells, e.g. 

Public Function Divider (ByVal Dividend As Double, ByVal Divisor As Double)
If IsNothing(Divisor) Or Divisor = 0
  Return 0
Else
  Return Dividend/Divisor
End If
End Function

You can then call this in a cell like so:

=Code.Divider(Fields!FieldA.Value, Fields!FieldB.Value)

More Related Contents:

  1. How do I format date and time on ssrs report?
  2. Passing multiple values for a single parameter in Reporting Services
  3. Left Outer Join Not Working?
  4. Sql PIVOT and string concatenation aggregate
  5. how to remove time from datetime
  6. ORA-01843 Not a valid month
  7. SQL Server recursive self join
  8. Insert data in 3 tables at a time using Postgres
  9. How to simulate UNPIVOT in Access?
  10. Real life example, when to use OUTER / CROSS APPLY in SQL
  11. How to get script of SQL Server data? [duplicate]
  12. Sql Server equivalent of a COUNTIF aggregate function
  13. Using ISNULL vs using COALESCE for checking a specific condition?
  14. PostgreSQL: Which Datatype should be used for Currency?
  15. Add unique constraint to combination of two columns
  16. What does a transaction around a single statement do?
  17. format interval with to_char
  18. Joining multiple tables in SQL
  19. Array in IN() clause oracle PLSQL
  20. Transposing an sql result so that one column goes onto multiple columns
  21. INSERT VALUES WHERE NOT EXISTS
  22. Database efficiency – table per user vs. table of users
  23. How to use Timestamp_to_scn and Scn_to_timestamp in Oracle?
  24. How to get a list column names and datatypes of a table in PostgreSQL?
  25. Inner Joining three tables
  26. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  27. Is NATURAL (JOIN) considered harmful in production environment?
  28. is there a PRODUCT function like there is a SUM function in Oracle SQL?
  29. How to Select Every Row Where Column Value is NOT Distinct
  30. In SQL how do I get the maximum value for an integer?

Leave a Comment