Using iff in reporting services

• montserrat.deza

  Say Hey Kid

  Points: 695

  More actions

  July 17, 2017 at 10:15 am

  #402312

  Hello Im kind of new using reporting services functions and I need help building this logic,
  So I need to use an iff expression comparing a value and then calculating a price based on that,
  here is what I have but is not working:
  If LicenseValue=0.00 or null then I need to calculate Unit price * Qty else use the License Value

  Here is what I wrote.:

  =IIf(Fields!LicenseValue.Value=0.00 or null,Fields!UnitPriceFromAttr.Value*Fields!QtyPerPackage.Value,Fields!LicenseValue.Value)

  Anny suggestions?

• Thom A

  SSC Guru

  Points: 99126

  More actions

  July 17, 2017 at 10:17 am

  #1951211

  For the evaluation side of your IIF, you would need:
  Fields!LicenseValue.Value = 0.00 OR IsNothing(Fields!LicenseValue.Value)

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk