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
Hi Andrew,
Maery has you covered it seems. I just want to add that there exists in the Seats and Tickets cube, a field for Production Season Closing Date. Using that instead of Performance Date will return the same DDIFF for everything in a given Production Season, which may not be critical here, but could come in handy.