I have done it on report builder =IIF((code.Example(sum(IFF(Is nothing(Fields!sample_oct_2019.value),0,Fields!oct_2019.value)), (sum(IFF(Is nothing(Fields!sample_nov_2019.value),0,Fields!nov_2019.value)), (sum(IFF(Is nothing(Fields!sample_dec_2019.value),0,Fields!dec_2019.value)), Variables!oct19.value, Variables!nov19.value, Variables!Dec19.value))=0,(variables!oct19.value+variables!nov19.value+variables!dec19.value), (code.Example(sum(IFF(Is nothing(Fields!sample_oct_2019.value),0,Fields!oct_2019.value)), sum(IFF(Isnothing(Fields!sample_nov_2019.value),0,Fields!nov_2019.value)), sum(IFF(Isnothing(Fields!sample_dec_2019.value),0,Fields!dec_2019.value)), Variables!oct19.value, Variables!nov19.value, Variables!dec19.value)) )))*100/(variables!oct19.value+variables!nov19.value+variables!dec19.Value)
Can anyone please help me on this i m getting NaN and #Error