topic Re: Forumla Help in QlikView https://community.qlik.com/t5/QlikView/Forumla-Help/m-p/781776#M1048307 <HTML><HEAD></HEAD><BODY><P>Perfect,&nbsp; I just couldn't get the brackets in the correct place.&nbsp; Much appreciated!</P></BODY></HTML> Thu, 20 Nov 2014 07:36:18 GMT bazzaonline 2014-11-20T07:36:18Z Forumla Help https://community.qlik.com/t5/QlikView/Forumla-Help/m-p/781774#M1048305 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a formula similar to this;</P><P></P><P>sum(Jansales*Jantime)+sum(Febsales*Febtime)+sum(Marsales*Martime)</P><P></P><P>I need to divide the total result by 100 but can't get the expression to work.&nbsp; Can you help?</P><P></P><P>Note - the time are variables.</P><P></P><P>Thanks&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 19 Nov 2014 20:02:34 GMT https://community.qlik.com/t5/QlikView/Forumla-Help/m-p/781774#M1048305 bazzaonline 2014-11-19T20:02:34Z Re: Forumla Help https://community.qlik.com/t5/QlikView/Forumla-Help/m-p/781775#M1048306 <HTML><HEAD></HEAD><BODY><P>Maybe you are missing the parenthesis? </P><P></P><P>(sum(Jansales*Jantime)+sum(Febsales*Febtime)...) /100</P></BODY></HTML> Wed, 19 Nov 2014 20:36:27 GMT https://community.qlik.com/t5/QlikView/Forumla-Help/m-p/781775#M1048306 morgankejerhag 2014-11-19T20:36:27Z Re: Forumla Help https://community.qlik.com/t5/QlikView/Forumla-Help/m-p/781776#M1048307 <HTML><HEAD></HEAD><BODY><P>Perfect,&nbsp; I just couldn't get the brackets in the correct place.&nbsp; Much appreciated!</P></BODY></HTML> Thu, 20 Nov 2014 07:36:18 GMT https://community.qlik.com/t5/QlikView/Forumla-Help/m-p/781776#M1048307 bazzaonline 2014-11-20T07:36:18Z