Hoping someone can help. I have a query with the following expression.
Problem is if the amount ends up Zero Dollars it still shows it as an entry. How can I exclude Zero Dollar entries.
Any help would be greatly appreciated.
Problem is if the amount ends up Zero Dollars it still shows it as an entry. How can I exclude Zero Dollar entries.
Any help would be greatly appreciated.
Expected Payments: IIf(IsNull([actualpaymentamount]),[paymentamount],[paymentamount]-[actualpaymentamount])