i have a requirement to display count 1 if there is any product blocked/booked between 2 dates in cross tab?
cross tab has calendar date,product desc, and below count variable.
i tried using calendar date and sum(if( calendar date>=start date and calendar date<= end date)then 1 else 0)
getting error #computation error.
can anyone help with above error or am i missing anything.
i’m trying to count the active records between 2 dates.
ravi342 (BOB member since 2012-08-06)