Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try: max({1} TOTAL INVOICEDATE)
- Marcus
You need to calculate your expression in total context:
=Max({1} TOTAL INVOICEDATE)
Try:
max( Total {1} INVOICEDATE)