Need a formula

[GRECONCG]

I need a formula to do this:

If invoice total is negative don't show payment applied or invoice balance.

How would I do this?

 

[dunlop1975]

I think you need to provide more info,also show a sample of what you would like the display to look like.

 

[GRECONCG]

I have a credit memo and the invoice total shows a negative number, I want to get rid of the payment applied which is a positive number and invoice balance which is 0 (because the positive number and negative number made the balance 0)
I would really like for it to say CREDIT ON FILE if the payment applied comes out to a positive numnber. Right now I have my payment applied formulas as:

IF {INVOICE.TRANS_TYPE}='R' and {INVOICE.POSTADJ}>0 then {INVOICE.POSTADJ} else {INVOICE.REMITTED}

so that is showing a positive number because of the return and an invoice balance of 0 since the - and + = 0.