Expression error
IIF(SUM(Fields!EXT_PRICE.Value)=0,-100,SUM(Fields!GROSS.Value)/SUM(Fields!EXT_PRICE.Value)) The above expression Runs but i get an #Error in the text box.... any ideas?FM
August 29th, 2012 1:46pm

Hi, Actually, SSRS eveluates both parts of IIF in advance, so you need to use below expression = IIF(SUM(Fields!EXT_PRICE.Value)=0,-100,SUM(Fields!GROSS.Value)/IIF(SUM(Fields!EXT_PRICE.Value) = 0,1,SUM(Fields!EXT_PRICE.Value))) - Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
August 29th, 2012 1:56pm

THank you CHintak.. works greatFM
August 29th, 2012 2:12pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics