Sum Issue (and then some!)

[proximity]

Hi everyone,

I have a calculation on a report:

=Sum(IIf([Var]>=1,[Var],0))+rptSubDiscrepNotAdvised.Report!txtOvers-1

This gives me the desired result.

How can I change the calculation so that it only works if a value of 999/9999 (in a field - a text field - called txtCat) is not returned? Or to put it another way, I want it to minus 1 off the result if there is a value of 999/9999 returned and to not minus it if there isn't!!!!

Hope I have explained it correctly!

Many thanks.

 

[lameid]

=Sum(IIf([Var]>=1,[Var],0))+ rptSubDiscrepNotAdvised.Report!txtOvers - IIF(txtCat = "999/9999", 1, 0)

I assumed of course your value was a single text value.