Excluding date KPI

[Simon4]

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

[BrunPierre]

Try

Avg({<Planneddate-={'01-01-9999'}>}Goodsreceiptdate-Planneddate)

[vinieme12]

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)