Showing posts with label fieldsfeeschedule. Show all posts
Showing posts with label fieldsfeeschedule. Show all posts

Saturday, February 25, 2012

Round producing no value

why is this producing nothing when zero?

=Round(((Fields!FeeGoal_IL.Value) / IIf(Fields!FeeSchedule.Value = 0, 1, Fields!FeeSchedule.Value)) * 100)

actually ever since I changed my format to #,### I think that's the problem

figured it out. It is not obvious in BOL (at least what I read on the lousy BOL for SSRS 2005 - lack of thorough content in SSRS 2005 BOL pages) that you can combine N and 0 so N0 did the trick for the format to format numbers with a comma less decimals (e.g. 1,200) and still render 0 for zero values