Sum results give me negative values !

[Costa]

Hello all

I have a field named (Location) with 5 entries (A,B,C,D,E)

I used this formula to calculate the sum of all records that have a certain entry ..

=Sum([Location]="A") , To give me all the records that contains "A" as an entry .. The formula work fine but the results are comes up with a minus next to them !!! Like Sum= -8 !! Why it gives me the results in minus ?



Is there anyway to remove this minus sign?

Is my formula Ok to get the information I want ?

Thanks all

[pbaldy]

Because True is represented by -1. Try this:

=Sum(IIf([Location]="A", 1, 0))

You could also use the Abs() function around what you have now, but this will be more useful in the long run.

[Costa]

Because True is represented by -1. Try this:

=Sum(IIf([Location]="A", 1, 0))

You could also use the Abs() function around what you have now, but this will be more useful in the long run.

Thanks mate for the help ..

I have another question, I want to edit the formula to get the sum of Location fields with "A" or "B" entries together in one result ?

I tried : =Sum(IIf([Location]="A" Or "B")) but didn't work !!!

any idea ?

Thanks again

[pbaldy]

You have to repeat the field, just like in SQL:

[Location]="A" Or [Location]="B"

[Costa]

You have to repeat the field, just like in SQL:

[Location]="A" Or [Location]="B"

Thanks for the help .. worked fine