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:
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.