topic formula syntax in QlikView https://community.qlik.com/t5/QlikView/formula-syntax/m-p/158086#M33314 <HTML><HEAD></HEAD><BODY><P>You missed max</P><P><B>Sum</B> (<B>Aantal</B>) - <B>Sum</B> (<B>Aantal1</B>)/ <STRONG>max</STRONG>(<B>Maand1)</B></P></BODY></HTML> Thu, 19 Nov 2009 19:48:50 GMT 2009-11-19T19:48:50Z formula syntax https://community.qlik.com/t5/QlikView/formula-syntax/m-p/158084#M33312 <HTML><HEAD></HEAD><BODY><P>Helo,</P><P>I've got 2 values.</P><P>Value 1 = <B>Sum</B> (<B>Aantal</B>)<BR />Value 2 = (<B>Sum</B> (<B>Aantal1</B>))/ <B>Max</B> (<B>Maand1</B>)<BR /></P><P>Value 1 returns 150<BR />Value 2 returns 250</P><P>Now I want Value 1 - Value 2 = -100</P><P>I've tried (<B>Sum</B> (<B>Aantal</B>)) - (<B>Sum</B> (<B>Aantal1</B>))/ <B>Maand1</B>) but does not work</P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">Sum</P><B></B><P style="font-weight: bold"></P>(<B>Aantal</B>) - <B>Sum</B> (<B>Aantal1</B>)/ <STRONG>Maand1</STRONG> also does not work<BR /><BR /> <BR /><BR /> <P></P></BODY></HTML> Thu, 19 Nov 2009 19:04:42 GMT https://community.qlik.com/t5/QlikView/formula-syntax/m-p/158084#M33312 2009-11-19T19:04:42Z formula syntax https://community.qlik.com/t5/QlikView/formula-syntax/m-p/158085#M33313 <HTML><HEAD></HEAD><BODY><P>It has to be work, can you share us the file</P></BODY></HTML> Thu, 19 Nov 2009 19:38:51 GMT https://community.qlik.com/t5/QlikView/formula-syntax/m-p/158085#M33313 shumailh 2009-11-19T19:38:51Z formula syntax https://community.qlik.com/t5/QlikView/formula-syntax/m-p/158086#M33314 <HTML><HEAD></HEAD><BODY><P>You missed max</P><P><B>Sum</B> (<B>Aantal</B>) - <B>Sum</B> (<B>Aantal1</B>)/ <STRONG>max</STRONG>(<B>Maand1)</B></P></BODY></HTML> Thu, 19 Nov 2009 19:48:50 GMT https://community.qlik.com/t5/QlikView/formula-syntax/m-p/158086#M33314 2009-11-19T19:48:50Z