This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to create a field that will count the consecutive day on hands are out of stock. I believe i can accomplish this with the multi - tool formula, but i'm receiving errors in the tool with attempting.
Below is an example of my data. Item_location 6462806464 i would expect a count of 3 and item_location 9724996471 i would expect a count of 7.
I used a multi-row formula to simply count the rows, grouped by item_location. Then I used a formula tool to reduce that number by 1 since we don't want to include the first day as a whole day out of stock. To get the number to be the same for every line instead of having a running count, you would just need to summarize, find the max and re-join with your original data set just like @Thableaus did.