In report, I would like to have condition like=IIf(Fields!GoldColorEName = "Yellow",Sum(Fields!Weight),""). how to create IIF condition thanks in advance......!!makeshmdk

Hi There I would think it will be like this =sum(IIf(Fields!GoldColorEName.value = "Yellow",Fields!Weight.value,0)) If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.