1 of 1 people found this helpful
I guess you're using older version so unable to share you the workbook. However I've shared you how to get the expected output as per your requirement. You can use ZN() function also to handle the NULLs.
Small change in your calculation.
Hope this help. Let me know If you've any query.
Clever. Thanks for the help!