Why error in expression

[#1]

In Edit window this expression calls an error

max(sum(asecs*0.04166666))

[john_duffy]

Hello.

The sum(asecs*0.04166666) calculation is only going to return one value per chart dimensions. There is no max. You could use the max funtion if you were aggregating the calculation over a dimension - eg. max(aggr(sum(asecs*0.04166666),Fieldxx)).

John.

[#3]

Hi,

You must write the expression as following:

=Max(Sum(asecs)) * 0.04166666

It's better and optimized.

Regards.