topic Re: Max date in expression in App Development

Max date in expression

irmantas — Tue, 19 Dec 2017 13:21:00 GMT

Hello,

I have dimensions ItemId, InventLocaionId, ValidateDate, InventBachId, how I can find MAX Transdate in expression, if I need MAX TransDate by InventBachId ?

Re: Max date in expression

YoussefBelloum — Tue, 19 Dec 2017 13:25:20 GMT

Hi,

can you attach some data ?

you want to display max date on a column as expression or you want to filter with max date inside an expression ?

Re: Max date in expression

irmantas — Tue, 19 Dec 2017 13:27:20 GMT

I want show it in column as expression.

Re: Max date in expression

YoussefBelloum — Tue, 19 Dec 2017 13:29:36 GMT

so if your Transdate column is formatted as a date, you can simply use Max(Transdate), if not, use: Max(Date(Transdate))

Re: Max date in expression

irmantas — Tue, 19 Dec 2017 13:37:23 GMT

Some data:

ItemId InventLocationId ValidateDate InventBachId TransDate

111 A 12/12/2017 X 10/12/2017

111 B 13/12/2017 X 11/12/2017

111 A 13/12/2017 X 12/12/2017

111 A 20/01/2018 Y 14/12/2017

I need to find:

ItemId InventLocationId InventBachId MaxTransDate

111 A X 12/12/2017

111 B X 12/12/2017

Excluding InventLocationId MAX TransDate of X is 12/12/2017

Re: Max date in expression

YoussefBelloum — Tue, 19 Dec 2017 13:57:36 GMT

so try this:

=aggr(NODISTINCT Max(Date(TransDate)),InventBachId)

Re: Max date in expression

irmantas — Wed, 20 Dec 2017 06:14:35 GMT

Thank you Youssef