Formula returns 1

[ChipF]

This formula is showing a 1 even if nothing happened that day. I got a report from Sunday where no one was working and it returned all 1s. It does the same for the MonthToDate field.

If {DLY_ACTIVITY.ACTIVITY_DT} = currentdate - 1 Then
{DLY_APPLICATION.LOAN_AM}
Else
0

 

[stormtrooper]

You should verify the the data in the {DLY_APPLICATION.LOAN_AM} field is not only 1's. To do this, drop that field into your detail section.

Also try "0" instead of just 0.

 

[ChipF]

I wanted an employee's daily and MTD "QR" occurances in two separate fields. So I created the formulas like the one above. I also have the selection formula looking for "QR".

I have summary totals on those 2 formulas. It adds fine when there was work, but when no one did anything it still gives me a 1. Need anymore info?