Sum Produces Negative Number - I Want Positive (1 Viewer)

[statsman]

What is the format to change the negative to a positive when:

=Sum([Field]="Novice")

Text box in report

 

[trucktime]

Sum

Try this if 'Novice' is the name of the field.

=Sum([Novice])

 

[statsman]

Sorry for not being clear
"Novice" is the condition I want to sum for
-how many records in the specific Field contain the text NOVICE?

Everything works fine except the returned sum is a negative number. There is a formula you can put into the format to return a positive number. I've just forgotten it.

Thanks

 

[trucktime]

Sum

OK, try this:

=Sum(IIf([Field]="Novice",1,0))

 

[RV]

"Novice" is the condition I want to sum for
-how many records in the specific Field contain the text NOVICE?

You're using the wrong function.
Use Count.
Add a WHERE clause to count only on your column having value NOVICE.

RV

 

[statsman]

Thanks guys, got it working