In SSRS how we can rectify NaN to 0

Viewed 9

=(((Variables!Apr22.Value+Variables!May22.Value+Variables!Jun22.Value)-(IIF((Code.Sum(SUM(IIF(IsNothing(Fields!Sample_April_2022.Value),0,Fields!Sample_April_2022 Value)), SUM(IIF(IsNothing((Fields!Sample_May_2022.Value),0,Fields!Sample_May_2022.Value)), SUM(IIF(IsNothing((Fields!Sample_June_2022.Value),0,Fields!Sample_June_2022.Value)), Variables!Apr22.Value, Variables!May22.Value, Variables!Jun22.Value))=0,(Variables!Apr22.Value+Variables!May22.Value+Variables!Jun22.Value), (Code.Sum(SUM(IIF(IsNothing(Fields!Sample_April_2022.Value),0,Fields!Sample_April_2022.Value)), SUM(IIF(IsNothing((Fields!Sample_May_2022.Value),0,Fields!Sample_May_2022.Value)), SUM(IIF(IsNothing((Fields!Sample_June_2022.Value),0,Fields!Sample_June_2022.Value)), Variables!Apr22.Value, Variables!May22.Value, Variables!Jun22.Value)) )))*100)/(Variables!Apr22.Value+Variables!May22.Value+Variables!Jun22.Value)

0 Answers
Related