Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In Edit window this expression calls an error
max(sum(asecs*0.04166666))
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.
Hi,
You must write the expression as following:
=Max(Sum(asecs)) * 0.04166666
It's better and optimized.
Regards.