calculating the maximal value

[Anonymous]

Hi,

I have a straight table in my application.

It has a dimention = Position

It has an expression which is defined by a variable = $(Reach)

My task is to calculate the maximal Reach in this straight table.

I try to calculate it in a separate text box.

So, I'm trying the following expression:

=max(aggr($(Reach), Position))

But it doesn't work. The result is incorrect.

Could you advise how I can calculate the maximal Reach?

Thank you in advance,

Larisa

[Anonymous]

Thanks, everyone, for your answers! It was helpful.

I've found out that Max value was calculated correctly.

It was expression in my straignt table which gave a wrong result.

I changed the expression in my straight table as Elena suggested:

previous: $(Reach)

new: aggr($(Reach), Position)