Hi all,I'm hoping to include a count of the number of days until the Prod Season end so that I can use this figure to calculate the average sales needed each day to hit our target budget, but I'm having some difficulty calculating this value.I'm sure there's a simple solution I'm just not thinking of, and coupled with a foggy Friday morning brain I just haven't been able to unearth it.Cheers,Andrew
I am using MIN(DDiff([Days in Date],NOW([Days in Date]))) (where Days in Date is the Performance Date) as a formula to calculate the start of the production season in order to sort productions in season order. I think if you switch that to MAX, you'd get what you want?
Brilliant. That worked. Thank you so much, Maery!