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