Yes/No field Sum

[bethabernathy]

Hi -

I am trying to Sum a Yes/No field in a report. The field is "numberofaccidents"

This is what I am using:

=Sum([Liftrelated])

The result I get is -3 and I need it to display as 3.

 

[nomus1]

Would it be as simple as taking the result * -1 ??

 

[bethabernathy]

Awesome!!! Yes it was as simple as that. Of course, I couldn't figure out the syntax. Thank you so much for your great help.

Beth

 

[JoeMiller]

It may be easier for you to use the Absolute value function then *-1, I've always felt it's easier to understand when reviewing code:

=Abs(Sum([Liftrelated]))

HTH Joe Miller
joe.miller@flotech.net