Dear community,
currently I am working with rangesum to look how my stock is going on.
I use this function :
=Sum(Stock) - RangeSum(above(Aggr(sum("Income/outcome"),material, calender_week),0,RowNo()))
I get for each material the stock for each calender_week.
My Question: How do I get explicit data from the rangesum like:
1. The first calender_week where the stock is less 0
2. The Min or Max value for the stock inside the rangesum
I need the values for each material like:
Material | first calender_week where the stock is less 0
A | Calender_Week 45
B | Calender_Week 35
C | Calender_Week 40
or
Material | Min value for the stock inside the rangesum
A | -50
B | 40
C | 20
I would appreciate any advice
Best regards
Will
