I have another issue today where I'm trying to add up some values.

if IsNull({pNVAnnualReportMedicalSection;1.BoxA_amt}) then 0 else {pNVAnnualReportMedicalSection;1.BoxA_amt}+
if IsNull({pNVAnnualReportMedicalSection;1.BoxB_amt}) then 0 else {pNVAnnualReportMedicalSection;1.BoxB_amt}+
if IsNull({pNVAnnualReportMedicalSection;1.BoxC_amt}) then 0 else {pNVAnnualReportMedicalSection;1.BoxC_amt}+
if IsNull({pNVAnnualReportMedicalSection;1.BoxD_amt}) then 0 else {pNVAnnualReportMedicalSection;1.BoxD_amt}+
if IsNull({pNVAnnualReportMedicalSection;1.BoxE_amt}) then 0 else {pNVAnnualReportMedicalSection;1.BoxE_amt}+
if IsNull({pNVAnnualReportMedicalSection;1.BoxF_amt}) then 0 else {pNVAnnualReportMedicalSection;1.BoxF_amt}+
if IsNull({pNVAnnualReportMedicalSection;1.BoxG_amt}) then 0 else {pNVAnnualReportMedicalSection;1.BoxG_amt}+
if IsNull({pNVAnnualReportMedicalSection;1.BoxH_amt}) then 0 else {pNVAnnualReportMedicalSection;1.BoxH_amt}+
if IsNull({pNVAnnualReportMedicalSection;1.BoxI_amt}) then 0 else {pNVAnnualReportMedicalSection;1.BoxI_amt}+
if IsNull({pNVAnnualReportMedicalSection;1.BoxJ_amt}) then 0 else {pNVAnnualReportMedicalSection;1.BoxJ_amt}+
if IsNull({pNVAnnualReportMedicalSection;1.BoxK_amt}) then 0 else {pNVAnnualReportMedicalSection;1.BoxK_amt}+
if IsNull({pNVAnnualReportMedicalSection;1.BoxL_amt}) then 0 else {pNVAnnualReportMedicalSection;1.BoxL_amt}

 

The problem is that BoxC value is Null, so from there it's stopping adding the next vales.

so, for ex if baxA.vales  is 10 and boxB.value is 5 and BoxC.value is null, and BoxD.value is 15 the total value is displaying as 15. It stops.

 

Can some one suggest what I might be doing wrong here?

Thanks a bunch in advance!