Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need the expression for a new field.
if event date is min show only the forecast date which is >event date
if event date is max show only the forecast date which is <event date. and make other dates as Null
Thankyou
Vam
Try this:
if (min(event_date)>event_date, forecast_date,
if(max(event_date)<event_date,forecast_date, '0'))
Regards,
T.
No Tereza its not working..