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