I'm trying to get a KPI to show a the last year/week where I have positive inventory. The underlying data set looks like the below. I'm trying to get a max yearweek with the set inventory greater than 0. Is this possible, what syntax would I use? Really appreciate any help.
Solved! Go to Solution.
Thank you both it's really helpful.
If I then also wanted to sum the inventory for all 3 weeks where the inventory is > than 0, how would I use set analysis to do that? Is that possible? (I have another column I want the values for)
Hi sorry I should have been more specific. I have a third column I want to sum (forecast), but I only want to consider the forecast where inventory is greater than 0. Is it possible to use set analysis to get the sum of the forecast for weeks where inventory is greater than 0?