topic Re: Select Most Recent Record in App Development

Select Most Recent Record

nrwlafhus — Fri, 24 Sep 2021 15:39:02 GMT

I am trying to select to most recent record where Planned = 'N' (for the given combination of dimensions).

Here is my table:

I want the output to only show the following highlighted row:

Is there a way to achieve this using a chart expression?

rubenmarin — Sat, 25 Sep 2021 15:02:24 GMT

Hi, you can using an expression like:

Sum({<Date={"$(=Max({<Planned={N}>} Date))"},Planned={N}>} Tons)

Maybe you need the add a date format:

Sum({<Date={"$(=Date(Max({<Planned={N}>} Date),'M/D/YYYY'))"},Planned={N}>} Tons)