topic Re: code error in QlikView https://community.qlik.com/t5/QlikView/code-error/m-p/729870#M1075490 <HTML><HEAD></HEAD><BODY><P>enclose within square brackets</P><P></P><P>=pow(sum([Current QTD Sales])/sum([Previous Sales]),1/30)-1</P></BODY></HTML> Wed, 23 Jul 2014 03:13:56 GMT 2014-07-23T03:13:56Z code error https://community.qlik.com/t5/QlikView/code-error/m-p/729869#M1075489 <HTML><HEAD></HEAD><BODY><P>Hello, I have been trying to figure this out for the past half hour - why is the function code in black? Please see screenshot below:(notice that the sum is black instead of blue? </P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/62910_pastedImage_58.png" style="width: auto; height: auto;" /></P><P>Please advise, thanks!</P><P>W</P></BODY></HTML> Wed, 23 Jul 2014 02:48:09 GMT https://community.qlik.com/t5/QlikView/code-error/m-p/729869#M1075489 Anonymous 2014-07-23T02:48:09Z Re: code error https://community.qlik.com/t5/QlikView/code-error/m-p/729870#M1075490 <HTML><HEAD></HEAD><BODY><P>enclose within square brackets</P><P></P><P>=pow(sum([Current QTD Sales])/sum([Previous Sales]),1/30)-1</P></BODY></HTML> Wed, 23 Jul 2014 03:13:56 GMT https://community.qlik.com/t5/QlikView/code-error/m-p/729870#M1075490 2014-07-23T03:13:56Z Re: code error https://community.qlik.com/t5/QlikView/code-error/m-p/729871#M1075491 <HTML><HEAD></HEAD><BODY><P>Hi Ramkumar</P><P></P><P>pow process try </P><P>pow(x,y)</P><P>=pow(sum([Current QTD Sales]) / sum([Previous Sales]),(1/30)-1)</P><P></P><P>reds</P><P>rudra</P></BODY></HTML> Wed, 23 Jul 2014 03:22:16 GMT https://community.qlik.com/t5/QlikView/code-error/m-p/729871#M1075491 2014-07-23T03:22:16Z Re: code error https://community.qlik.com/t5/QlikView/code-error/m-p/729872#M1075492 <HTML><HEAD></HEAD><BODY><P>This thread should be marked as answered</P></BODY></HTML> Wed, 23 Jul 2014 03:48:16 GMT https://community.qlik.com/t5/QlikView/code-error/m-p/729872#M1075492 sujeetsingh 2014-07-23T03:48:16Z Re: code error https://community.qlik.com/t5/QlikView/code-error/m-p/729873#M1075493 <HTML><HEAD></HEAD><BODY><P>Hi, i think they should work. I havent tried yet, it's my morning here.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 23 Jul 2014 13:20:59 GMT https://community.qlik.com/t5/QlikView/code-error/m-p/729873#M1075493 Anonymous 2014-07-23T13:20:59Z Re: code error https://community.qlik.com/t5/QlikView/code-error/m-p/729874#M1075494 <HTML><HEAD></HEAD><BODY><P>If you are trying to reference a field with spaces in between them you should enclose the field with [ ]'s.</P><P></P><P>As shown above.</P><P></P><P>Regards,<BR />Marius</P></BODY></HTML> Wed, 23 Jul 2014 13:26:03 GMT https://community.qlik.com/t5/QlikView/code-error/m-p/729874#M1075494 2014-07-23T13:26:03Z Re: code error https://community.qlik.com/t5/QlikView/code-error/m-p/729875#M1075495 <HTML><HEAD></HEAD><BODY><P>Hello... something is still not right.. I am getting null even though they are numbers in both fields... why is that?</P><P></P><P>Thanks!</P><P>W</P></BODY></HTML> Fri, 25 Jul 2014 03:03:10 GMT https://community.qlik.com/t5/QlikView/code-error/m-p/729875#M1075495 Anonymous 2014-07-25T03:03:10Z