Showing table field in sql server if not equal to 0

Question

Can anyone help me with my requirement below?

If Debit is not equal to Credit, I want the data to show. But if Debit and Credit is now balance, no data should show. I have no luck with the having clause. Thanks in advance.

Piyush Pansuriya · Answer

Hello If CashierID not required than remove it.. Because in grouping CashierID is not similar in both row.

Hold On · Answer

Piyush Pansuriya thanks. Got it already

Hold On · Answer

Piyush Pansuriya thanks for your reply. I tried your suggestion but regardless if balance or not it shows all the data. Please see attached photo. not balance data: In the pix above Debit is greater than Credit so the data shows. balance data: In the photo above Debit and Credit were already balance so therefore this data show not show. The requirement is that: if Debit = Credit then no data should show. If Debit > Credit then data should show.

Piyush Pansuriya · Answer

Hello Put ISNULL() to all numeric field. i.e. ISNULL(sr.AccountsReceivable0) and change in having like having sum(ISNULL( sr.AccountsReceivable0)) - (SUM(ISNULL(ar.Premium0) + .....)) 0