topic Re: SQL table origined field returns the correct answer but gives a minus value? in App Development https://community.qlik.com/t5/App-Development/SQL-table-origined-field-returns-the-correct-answer-but-gives-a/m-p/1270239#M26094 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample where you are seeing this weird behavior?</P></BODY></HTML> Fri, 10 Mar 2017 15:14:39 GMT sunny_talwar 2017-03-10T15:14:39Z SQL table origined field returns the correct answer but gives a minus value? https://community.qlik.com/t5/App-Development/SQL-table-origined-field-returns-the-correct-answer-but-gives-a/m-p/1270238#M26093 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a strange outcome in a table.</P><P></P><P>When I do Sum(Counter) I get a minus value with the correct answer.</P><P></P><P>So for example the SQL table may look like:</P><P></P><TABLE border="1" class="jiveBorder" height="150" style="border: 1px solid rgb(0, 0, 0); width: 168px; height: 110px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Counter</TH></TR><TR><TD style="padding: 2px;">1212</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">3434</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">6342</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">6722</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">3497</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>When I do Sum(Counter) in the UI I am expecting a 5.</P><P></P><P>However I get a -5</P><P></P><P>Any idea why?</P><P></P><P>I tried making sure the counter field is a Num by wrapping the function around the field.</P><P></P><P>I also did If(Counter = 1, 1,0) but it does not work.</P></BODY></HTML> Fri, 10 Mar 2017 15:11:24 GMT https://community.qlik.com/t5/App-Development/SQL-table-origined-field-returns-the-correct-answer-but-gives-a/m-p/1270238#M26093 jblomqvist 2017-03-10T15:11:24Z Re: SQL table origined field returns the correct answer but gives a minus value? https://community.qlik.com/t5/App-Development/SQL-table-origined-field-returns-the-correct-answer-but-gives-a/m-p/1270239#M26094 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample where you are seeing this weird behavior?</P></BODY></HTML> Fri, 10 Mar 2017 15:14:39 GMT https://community.qlik.com/t5/App-Development/SQL-table-origined-field-returns-the-correct-answer-but-gives-a/m-p/1270239#M26094 sunny_talwar 2017-03-10T15:14:39Z