I want to create a formula that will return the average of sales within 30 days of the latest date in the period I select within my app. I have tried several approaches, but they aren't giving me the result I would expect.
Sorry - this actually looks a bit off. Not 100% sure what's driving the outage, but the Sales amounts in the for the dates in question are pretty different in the visualization where I use that formula vs. a basic sum of the Sales for the same period in a basic table. I'll dig in and let you know if I determine outage.