#Value error in SSRS

• eobiki10

  SSCrazy

  Points: 2390

  More actions

  December 12, 2013 at 12:33 pm

  #287360

  Hi folks,

  I have this expression in my SSRS report and one the fields is coming up as #Value. Please can you help me dictate where the error might have come from?

  =iif(iserror(sum(iif(iif(Fields!original_estimated_fee.Value

  is nothing,0,Fields!original_estimated_fee.Value)=0,cint(0),iif(Fields!original_estimated_fee.Value is nothing,0,Fields!original_estimated_fee.Value)))),0,sum(iif(iif(Fields!original_estimated_fee.Value is nothing,0,Fields!original_estimated_fee.Value)=0,0,iif(Fields!original_estimated_fee.Value is nothing,cint(0),cint(Fields!original_estimated_fee.Value)))))

  THANKS

  EO

• Ville-Pekka Vahteala

  SSCrazy

  Points: 2458

  More actions

  December 12, 2013 at 2:50 pm

  #1673098

  What are you trying to do?

  There must be easier way to this.