Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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