Simple Powerpivot Query

[Grinch356]

Hi,

I am trying to do a days of stock calculation in powerpivot and struggling to get it to work. In excel the calcualtion would be alonf the lines of:

if(Average 4 weeks forward forecast>0) (TEF Stock + VMI Stock) / Average 4 weeks forward sales forecast= DOS

I need this as a measure so when I move between views, from item to vendor etc it calculates still, can anyone please help?

Thanks

 

[scottsen]

Gonna probably need more to go on. Like... do you have a calendar table? Is the "4 weeks forward sales forecast" something precomputed? Some info about your table (or a screen shot of the model) or something...?