SSRS Expression Help

• Jeffs1977

  SSC-Addicted

  Points: 487

  More actions

  July 31, 2019 at 8:29 pm

  #3667693

  I need help adding onto my SSRS Expression. If the value is zero, i am getting nothing returned to the report. I believe I need to call IsNothing and return a 0; however, I am not getting too lucky on the syntax. Can I get a hand?

  =Avg(IIF(Fields!NextService.Value = "Substance Abuse", Fields!DaysToNextService.Value, NOTHING))

• Andrey

  SSC Eights!

  Points: 840

  More actions

  July 31, 2019 at 8:53 pm

  #3667705

  =IIF(Fields!NextService.Value = "Substance Abuse",Fields!DaysToNextService.Value,0)
  

  ?

   

  PS usage of AVG in the original expression is not clear