Can you share a sample workbook or a snapshot of what you are trying to achieve ?
Could you try with ZN(LOOKUP(SUM([A]), 0))
If i understand your need correctly, you tried to do null handling. You can show null values as 0 by following the steps below.
Right click on text label > Edit in Shelf > IFNULL([Your text label],0)