Change formula

[#1]

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

[eddysanchez]

Hi Amv,

If you add the dimension "Year" in your chart, this will work

But I think you need to understand your formula, press F1 and search what makes each formula of your expression