Hoping to get help with my widget formula. I'm trying to calculate the total day of sales for all events in a season. My logic is to fsum the total ticket paid IF the order date is more than or equal to the event date.
Days in Date = order_date
Days in Date1 = event_date
sum( if( [Days in Date]>= [Days in Date1], [Total Ticket Paid Count], 0 ))
Hi Jonathan,
The [Order Days from Performance] will be 0 for same day sales. So you can either filter the widget or your formula sum on [Order Days from Performance] = 0. E.g.
( [Total Ticket Paid Count] , [Order Days from Performance = 0] )
That worked. Thanks!