Avg function throwing an error

[#1]

Hello,

I have an expression like this which works correctly.

Interval(if(len(Max(END_DATE))=0,Today(),Max(END_DATE))-Min(START_DATE),'dd')

But When i tried to do an average of it, it says Error in Expression.

Avg(Interval(if(len(Max(END_DATE))=0,Today(),Max(END_DATE))-Min(START_DATE),'dd'))

Could anyone understand the mistake in this? START_DATE and END_DATE are timestamps.

Thanks

Ramakanth

[swuehl · Accepted solution]

You are embedding max() aggregation function into another aggregation function, avg(), which is not possible without using advanced aggregation aggr() function.