error in set modifier expression for avg expression with clause

[matthewp]

My expression will not work and i am getting the error "error in set modifier expression", it is only a simple expression but i cant understand why it wont work.

avg({<NOT ISNULL([table.ApproveDate])>} table.days)

[sunny_talwar]

I would suggest to create a new field in the script like this

LOAD table.ApproveDate,

           If(Len(Trim(table.ApproveDate)) = 0, 1, 0) as NullFlag

Now you can try like this:

Null

Avg({<NullFlag = {1}>} table.days)

Not Null

Avg({<NullFlag = {0}>} table.days)