This will give you the a 0 if recovery is a negative value or the value of recovery-rec_nc if recovery is not negative.

Is that whaty you want it to do?

I am stil not sure how you have your report set up because it sounds like you have one field that you are trying to alter but you have two fields that you are using, gross_recovery(negative value=refund and +value=Cash) and gross_rec_nc which is all NonCash items.

My guess is that you have  a group on a client and then rows of data per type and then a SUm of these in the footer.

if that is correct then likely the SUM in the footer is a formula that sums the rec_nc fields and the recovery_field.

If I am at all close all ou have to do to change your SUm is to create a formual field to zero out your negative values and then SUM that formula field. Just leave the NonCash field out of it altogther.

 

Is this at all close to your actual report design/function? If not can you explain it or use this idea to make the changes?