Sum IIF Field Greater than 0

[on-2]

I am trying to create a field that displays a count on all records which are 1 or above.

I was using =Sum(IIf([financecompany]="Black Horse",1,0)) to count individual companies but i am trying to use the value field instead.

I searched and found a thread using =Sum(IIf([amounttofinance]>0,1,0))
but this gives me an invalid syntax message?.

Any help would be greatly appreciated.

 

[on-2]

Was being stupid - just figured it out - i will sum the 0 values and minus from the qty in the sum..

Thanks for looking