hi i create a matrix report in ssrs.. in that Data field i wrote expression like this =iif(Fields!NAME.Value="fund",Fields!VALUE.Value,nothing) but in that data filed i got null value i wrote same expression in calculated filed and i used it means i got a value...so how to write expression for filter value in data filed

hi Give a try to this =iif(Fields!NAME.Value="fund",Fields!VALUE.Value,"") Hope this will help you !!! Sanjeewan

ya thanks for ur reply.but i got answer for this this is the correct expression i want to give =sum(iif(Fields!NAME.Value="fund",Fields!VALUE.Value,nothing))

ya thanks for ur reply.but i got answer for this this is the correct expression i want to give =sum(iif(Fields!NAME.Value="fund",Fields!VALUE.Value,nothing))