Hi Hari,

It worked with a small modification. I used Switch instead of IIF.

sum(switch(Fields!Excise_Duty.Value <> 0,round(Fields!Quantity.Value)))

sum(switch(Fields!Excise_Duty.Value = 0,round(Fields!Quantity.Value)))

Thanks a lot for your help.

Cheers,

Hi Hari,

Thanks for your immediate response. This solution is logical, unfortunately while doing a preview, it is giving the result '#Error' value for these fields. I am confused because of...