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.
