Does the iif function compute both paths in SSRS or is it short-circuited?

by

You’re right, it doesn’t short circuit. That sucks.

You’ll have to do something like this:

= Iif(KgSold = 0, 0, Revenue) / Iif(KgSold = 0, 1, KgSold )

The switch function should also work.

More Related Contents:

  1. SSRS 2005 Set SimplePageHeaders on the report instead of the server?
  2. SSRS Conditional Formatting Switch or IIF
  3. The permissions granted to user ‘ are insufficient for performing this operation. (rsAccessDenied)”}
  4. Passing parameter via url to sql server reporting service
  5. SSRS multi-value parameter using a stored procedure
  6. Compare SQL Server Reporting Services to Crystal Reports [closed]
  7. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports are blank in Safari and Chrome
  8. SSRS Expression Divide by Zero Error
  9. Reporting Services export to Excel with Multiple Worksheets
  10. When to use RDLC over RDL reports?
  11. Fast query runs slow in SSRS
  12. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8… why?
  13. SSRS – How to build a simple multi-column report?
  14. SSRS – How to continue data to next column?
  15. SSRS distinct lookupset function
  16. How to combine aggregates within a group with aggregates across groups within SSRS
  17. Pivot a table in reporting services?
  18. Access Page number in report body In SSRS
  19. Performance difference between IIf() and If
  20. How to get rid of blank pages in PDF exported from SSRS
  21. Add alternating row color to SQL Server Reporting services report
  22. Sql PIVOT and string concatenation aggregate
  23. Why does the 2nd T-SQL query run much faster than the first when called by Reporting Services 2005 in a web-app
  24. divide by zero/null workaround in SSRS 2008 report
  25. Need help in calculation using two Datasets using Expression SSRS
  26. how to remove time from datetime
  27. SQL Reporting Services – Print Button not shown in Mozilla
  28. Optional multi-valued parameters in SSRS
  29. How to get total of top 10 sales in SSRS 2012
  30. Passing Credentials to Sql Report Server 2008

Leave a Comment