SQL table origined field returns the correct answer but gives a minus value?

[jblomqvist]

Hi all,

I have a strange outcome in a table.

When I do Sum(Counter) I get a minus value with the correct answer.

So for example the SQL table may look like:

ID	Counter
1212	1
3434	1
6342	1
6722	1
3497	1

When I do Sum(Counter) in the UI I am expecting a 5.

However I get a -5

Any idea why?

I tried making sure the counter field is a Num by wrapping the function around the field.

I also did If(Counter = 1, 1,0) but it does not work.

[sunny_talwar]

Would you be able to share a sample where you are seeing this weird behavior?