1 Reply Latest reply: Mar 10, 2017 10:14 AM by Sunny Talwar RSS

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

    John Blomqvist

      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:

       

      IDCounter
      12121
      34341
      63421
      67221
      34971

       

      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.