topic Re: FirstSortedValue on Max date in App Development

FirstSortedValue on Max date

Hauglaen — Tue, 05 May 2020 13:11:31 GMT

My dataset consist of a weekly report showing sales and inventory.

And I am having trouble displaying inventory for only the last week.

My current solution displays the latest inventory update for each ID and not only for the last week:

ALT(FirstSortedValue(Inventory,-Date),0)

Any suggestions?

Thanks!

agigliotti — Tue, 05 May 2020 13:32:47 GMT

could you explain better what are you trying to achieve?
what is your current result and what is your desired result?

Hauglaen — Tue, 05 May 2020 13:47:42 GMT

My dataset looks like this:

And I only want to see the latest inventory update:

My current solution includes 15 from ID 3 because its the latest value for the ID.

agigliotti — Wed, 06 May 2020 07:55:15 GMT

you case use the below expression:

sum( {< Date = {"$(=date(max(Date)))"} >}Inventory)

with Date and ID as dimensions.

Hauglaen — Wed, 06 May 2020 09:25:16 GMT

Your expression didnt work, but it sent me on the right path.

The following expression worked for me:

SUM( IF( Date = MAX(TOTAL Date), Inventory, 0 ))

Thank you!

agigliotti — Wed, 06 May 2020 10:20:33 GMT

please close this thread and mark the reply as solution if applicable.

Hauglaen — Wed, 06 May 2020 11:11:35 GMT

I tried sum( {< Date = {"$(=date(max( TOTAL Date)))"} >}Inventory)

But it just resulted in zeroes for each ID.