Using If function with ISNULL function - need help

[AbdullahJamil]

Hi Guys,

Can anyone help in correcting my below coding. 

Thanks

if(Process='PA'
,NetWorkDays([14. Tracking DCC response to PA]
,[01. Confirm impact for PA]
)
,if(Process='IA'
,NetWorkDays([30. Tracking DCC response to IA]
,if(IsNull([18. Mobilise virtual team for IA]
,if (IsNull([17. Confirm demand]
,[01. Confirm impact for PA])

)
)
)
)
, if(Process='CAN'
,Networkdays([36. Complete]
,if (IsNull([31. Resolve DCC IA queries.]
,if(IsNull([30. Tracking DCC response to IA]
,[01. Confirm impact for PA])))))
))))

[miskinmaz]

What is the problem and what is the expected output

[AbdullahJamil]

I need to make below mentioned table. required result is monthly average days occur in theses categories  ( PA , IA & CAN)

Months	May	Jun	Jul	Description
PA				Step 14 date - Step 01 date. average days in month (Month considered from Step 14 date)
IA				Step 30 date - Step 18 date if empty - step 17 date if empty - step 01 date. average days in month (Month considered from Step 30 date)
CAN				Step 36 date- Step 31 date if empty - step 30 date if empty - step 01 date . average days in month (Month considered from Step 36 date)

[Brett_Bleess]

Duplicate post, see https://community.qlik.com/t5/QlikView-Scripting/Help-Needed-in-Script-using-IF-amp-ISNULL/m-p/16073... for continuing thread.

Regards,
Brett