https://community.qlik.com/t5/QlikView/If-And-Question/m-p/1601288#M736738 <P>Try</P><P>SUM({&lt;C2={"&gt;0"},B2={"&gt;0"}&gt; }&nbsp;<SPAN>C2-B2)</SPAN></P> Thu, 11 Jul 2019 09:15:26 GMT SergeyMak 2019-07-11T09:15:26Z https://community.qlik.com/t5/QlikView/If-And-Question/m-p/1601254#M736736 <P>Hello,</P><P>I need help.</P><P>I have some criteria which consists of the following:</P><TABLE><TBODY><TR><TD>Name</TD><TD>Sales 2018</TD><TD>Sales 2019</TD><TD>Growth</TD></TR><TR><TD>A</TD><TD>155,471,000</TD><TD>218,313,000</TD><TD>62,842,000</TD></TR><TR><TD>B</TD><TD>0</TD><TD>160,174,100</TD><TD>0</TD></TR><TR><TD>C</TD><TD>201,561,300</TD><TD>0</TD><TD>0</TD></TR><TR><TD>D</TD><TD>335,127,700</TD><TD>246,324,000</TD><TD>-88,803,700</TD></TR><TR><TD>E</TD><TD>87,421,300</TD><TD>0</TD><TD>0</TD></TR><TR><TD>F</TD><TD>259,059,400</TD><TD>275,161,000</TD><TD>16,101,600</TD></TR><TR><TD>G</TD><TD>206,104,300</TD><TD>185,311,000</TD><TD>-20,793,300</TD></TR><TR><TD>H</TD><TD>195,334,400</TD><TD>0</TD><TD>0</TD></TR><TR><TD>I</TD><TD>203,839,100</TD><TD>196,328,000</TD><TD>-7,511,100</TD></TR><TR><TD>J</TD><TD>0</TD><TD>389,833,000</TD><TD>0</TD></TR><TR><TD>K</TD><TD>491,257,100</TD><TD>603,016,100</TD><TD>111,759,000</TD></TR><TR><TD>L</TD><TD>440,301,200</TD><TD>0</TD><TD>0</TD></TR><TR><TD>M</TD><TD>152,800,200</TD><TD>178,219,000</TD><TD>25,418,800</TD></TR><TR><TD>N</TD><TD>149,862,500</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>the idea is that :&nbsp;=IF(AND(C2&gt;0,B2&gt;0),C2-B2,0)</P><P>Any Ideas on how I can tackle this would be highly appreciated.</P><P>Thank you in advance for your time.</P><P>Fandy</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/If-And-Question/m-p/1601254#M736736 fandybow 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/If-And-Question/m-p/1601268#M736737 <P>try it like this:</P><P><SPAN>=IF(C2&gt;0 AND B2&gt;0,C2-B2,0)</SPAN></P><P><SPAN>regards</SPAN></P> Thu, 11 Jul 2019 08:44:17 GMT https://community.qlik.com/t5/QlikView/If-And-Question/m-p/1601268#M736737 zhadrakas 2019-07-11T08:44:17Z https://community.qlik.com/t5/QlikView/If-And-Question/m-p/1601288#M736738 <P>Try</P><P>SUM({&lt;C2={"&gt;0"},B2={"&gt;0"}&gt; }&nbsp;<SPAN>C2-B2)</SPAN></P> Thu, 11 Jul 2019 09:15:26 GMT https://community.qlik.com/t5/QlikView/If-And-Question/m-p/1601288#M736738 SergeyMak 2019-07-11T09:15:26Z