Positives and Negatives

[Candyman_mm]

I am doing a financial table in which I have one field with a gross total of combined debits and credits. Is there any way I can write a fuction that splits the total debits and total credits singularly, then give me a count of the items?

 

[Rich]

Iif([Somefield]<0,[Somefield],"")