Skip to Content
0
Former Member
Jul 18, 2008 at 08:42 PM

Totals For Columns With Values And Zeros For With No Values

25 Views

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;