OK, I've already gotten one question answered around this. Just to recap, I'm creating an alert monitoring system that will flag when a stock goes low stock or out of stock. I have a BOOLEAN for when a stock goes below 1 week of inventory and another line item that displays that start date of that week should we go out of stock, ditto the last day of the week.
Now, I want to pull the FIRSTNONBLANK of the start of the week and the last day and the LASTNONBLANK for the end of the week. This will give me my stock out time period. I've created a module that doesn't have a time dimension because all I want are those dates and then I can do some calculations based on those 2 dates. I've used this formula but it doesn't seem to be working
Weekly Scenario.Start of Week[FIRSTNONBLANK: Weekly Scenario.Start of Week]
and this
Weekly Scenario.End of Week[FIRSTNONBLANK: Weekly Scenario.Start of Week]
It's my understanding that the line item outside of the brackets is the test, meaning this is where we look for the first blank, and the second is what line is referenced. Any thoughts? These are my formulas for my weekly scenario tool that is driving the dates, I'm creating a separate Alert Monitor that will pull those dates out.