Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I looked around on the forum but I could not get to the solution.
I want to exclude the date 01-01-9999 from Planneddate
=avg(Goodsreceiptdate-Planneddate)
Can anybody help me?
Thanks in advance,
Simon
Try
Avg({<Planneddate-={'01-01-9999'}>}Goodsreceiptdate-Planneddate)
Try below
=avg({<Planneddate-={'01-01-9999'}>}Goodsreceiptdate-Planneddate)
Or below, where ID is field that identifies each record separately
=avg({<
ID=e({<Planneddate={'01-01-9999'}>}ID)
>}Goodsreceiptdate-Planneddate)