topic Help with formula in QlikView https://community.qlik.com/t5/QlikView/Help-with-formula/m-p/153011#M30230 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have the following formula:</P><P>(([Resolved]-[Exceptions])/[Resolved])</P><P>how do I change this so that it only shows where the following field IsServ = 1</P><P></P><P>Thanks</P><BR /><BR /></BODY></HTML> Thu, 21 Oct 2010 13:15:26 GMT ivandrago 2010-10-21T13:15:26Z Help with formula https://community.qlik.com/t5/QlikView/Help-with-formula/m-p/153011#M30230 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have the following formula:</P><P>(([Resolved]-[Exceptions])/[Resolved])</P><P>how do I change this so that it only shows where the following field IsServ = 1</P><P></P><P>Thanks</P><BR /><BR /></BODY></HTML> Thu, 21 Oct 2010 13:15:26 GMT https://community.qlik.com/t5/QlikView/Help-with-formula/m-p/153011#M30230 ivandrago 2010-10-21T13:15:26Z Help with formula https://community.qlik.com/t5/QlikView/Help-with-formula/m-p/153012#M30231 <HTML><HEAD></HEAD><BODY><P></P><P>if(IsServ=1,([Resolved]-[Exceptions])/[Resolved]))</P></BODY></HTML> Thu, 21 Oct 2010 13:32:19 GMT https://community.qlik.com/t5/QlikView/Help-with-formula/m-p/153012#M30231 2010-10-21T13:32:19Z Help with formula https://community.qlik.com/t5/QlikView/Help-with-formula/m-p/153013#M30232 <HTML><HEAD></HEAD><BODY><P>No not working</P></BODY></HTML> Thu, 21 Oct 2010 13:39:52 GMT https://community.qlik.com/t5/QlikView/Help-with-formula/m-p/153013#M30232 ivandrago 2010-10-21T13:39:52Z Help with formula https://community.qlik.com/t5/QlikView/Help-with-formula/m-p/153014#M30233 <HTML><HEAD></HEAD><BODY><P></P><P>Are these fields all in the same table?</P><P>If so try with sum(if(isServ=1,( (([Resolved]-[Exceptions])/[Resolved])))</P><BR /><BR /></BODY></HTML> Thu, 21 Oct 2010 13:45:35 GMT https://community.qlik.com/t5/QlikView/Help-with-formula/m-p/153014#M30233 lucas4bi 2010-10-21T13:45:35Z Help with formula https://community.qlik.com/t5/QlikView/Help-with-formula/m-p/153015#M30234 <HTML><HEAD></HEAD><BODY><P></P><P></P><P>=if(IsServ=1,(Resolved-Exceptions)/Resolved))</P><P>And this one?</P><P>What is the exception you get?</P><P></P><BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 21 Oct 2010 13:46:37 GMT https://community.qlik.com/t5/QlikView/Help-with-formula/m-p/153015#M30234 2010-10-21T13:46:37Z