AVG expression

[#1]

Hello

I have an expression in a table

max([Actual Completion Date]) - min([Actual Start Date])

I would like to have the average of this expression

Avg(max([Actual Completion Date]) - min([Actual Start Date]) )

This does not work.

The min and max is dependent on dimensions, I know.

Any ideas how to solve this?

[#2]

Hi ,

Try this interval(Avg(max([Actual Completion Date]) - min([Actual Start Date]) ))

[tresesco]

I guess you have to use TOTAL keyword (though that depends on your requirement).

[Gysbert_Wassenaar · Accepted solution]

If you need to nest aggregation functions you need to use the aggr function:

avg(aggr((max([Actual Completion Date]) - min([Actual Start Date]),Dim1, Dim2 ... ))

Replace Dim1, Dim2 ... with the dimensions over which min and max need to be aggregated.

[#5]

It worked!

Hats off!