topic Change formula in QlikView https://community.qlik.com/t5/QlikView/Change-formula/m-p/409488#M1157207 <HTML><HEAD></HEAD><BODY><P>I'm using the expression in bold to find the average days of inventory for multiple companies. It works when i select one company, but when i select two companies the formula doesn't work. </P><P>Basically, i want to take a company's (2010 inventory + 2011 inventory) /2) /(COGS)*365 What do i need to change in my expression so that it also works when i select two companies? Thank you. </P><P></P><P></P><P><STRONG>if(Year=Below(Year),(([Total Inventory]+Below([Total Inventory]))/2)/([COGS]))*365</STRONG></P></BODY></HTML> Tue, 05 Mar 2013 15:57:27 GMT 2013-03-05T15:57:27Z Change formula https://community.qlik.com/t5/QlikView/Change-formula/m-p/409488#M1157207 <HTML><HEAD></HEAD><BODY><P>I'm using the expression in bold to find the average days of inventory for multiple companies. It works when i select one company, but when i select two companies the formula doesn't work. </P><P>Basically, i want to take a company's (2010 inventory + 2011 inventory) /2) /(COGS)*365 What do i need to change in my expression so that it also works when i select two companies? Thank you. </P><P></P><P></P><P><STRONG>if(Year=Below(Year),(([Total Inventory]+Below([Total Inventory]))/2)/([COGS]))*365</STRONG></P></BODY></HTML> Tue, 05 Mar 2013 15:57:27 GMT https://community.qlik.com/t5/QlikView/Change-formula/m-p/409488#M1157207 2013-03-05T15:57:27Z Re: Change formula https://community.qlik.com/t5/QlikView/Change-formula/m-p/409489#M1157208 <HTML><HEAD></HEAD><BODY><P>Hi Amv,</P><P></P><P>If you add the dimension "Year" in your chart, this will work</P><P></P><P>But I think you need to understand your formula, press F1 and search what makes each formula of your expression</P></BODY></HTML> Tue, 05 Mar 2013 16:38:10 GMT https://community.qlik.com/t5/QlikView/Change-formula/m-p/409489#M1157208 eddysanchez 2013-03-05T16:38:10Z