Forum Discussion
Categorize Values by Timeframe
Hi, community, I have a matrix that looks like this: ITEM STOCK Week Number / Week Start 1 2 3 4 5 6 7 Item 1/01/2021 7/01/2021 14/01/2021 21/01/2021 28/01/2021 5/02/...
Hi Anonymous
As you said , negative is < 0 . Do you mean that the value of the seventh week is less than 0 ?If yes , then the result returned by d should also be Y. But the result you provided is N.
So your definition of negative is still not very clear , If possible, please give a detailed description of negative .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous ,
Y is only for negative in 6 weeks. Week 7 should not be included in this.