max i.s.o. sum in set analysis

[hansrokers]

In a straight tabel I have the field INVOICEDATE as the dimension.

In the expression I have max({1} INVOICEDATE)

I would expect always the highest date in the expression but is showing the dimension date.

When I create a textbox with =max({1} INVOICEDATE) it is showing the highest date, even when putting a filter on INVOICEDATE.

What am I doing wrong?

[marcus_sommer · Accepted solution]

Try: max({1} TOTAL INVOICEDATE)

- Marcus

[swuehl]

You need to calculate your expression in total context:

=Max({1} TOTAL INVOICEDATE)

[tresB]

Try:

max( Total {1} INVOICEDATE)