Why can't the below formula give me zeros (for columns with nothing in it) and a total for the columns with values in the column ?
NumberVar DollarAmt;
DollarAmt :=0;
If {tracking_file_primary.F628$02#Loan_Origination_Fee_Percent} <> 0 Then
DollarAmt :={tracking_file_primary.F7443#Loan_Amount_Including_One_Time_PMI_MIP}*{tracking_file_primary.F628$02#Loan_Origination_Fee_Percent}/100
Else
DollarAmt :=0;