1 Reply Latest reply: Mar 5, 2013 11:38 AM by Eddy Sanchez RSS

    Change formula

      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.

      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.



      if(Year=Below(Year),(([Total Inventory]+Below([Total Inventory]))/2)/([COGS]))*365