Chart Aggregation Function

[#1]

Is any one have idea that how to calculate this in aggregation function.

Sum((Max(EndDate)-MAX(StartDate)))

This is not working in my Calculation and return nothing.

[jagan]

Hi,

Where you are using this expression, in chart?  Can you provide some sample data, it is difficult to understand without data.

Regards,

Jagan.

[Gysbert_Wassenaar]

If you nest aggregation functions like sum and max you need to use the aggr function:

sum(aggr(max(EndDate)-max(StartDat),Dim1,Dim2,...,DimN))

Replace Dim1,Dim2,...,DimN with the dimensions of your chart,