topic Re: SUM(VALUES) based on MAX of another value in App Development

SUM(VALUES) based on MAX of another value

nilesh_gawali — Fri, 15 Nov 2024 21:20:55 GMT

=Max(Aggr(Sum(value), Date)) => this expression is giving max(sum(values), I want sum(values) for max date in provided range.

As soon as we select a date range, I want the sum of values (from another column) of the maximum date for that range.

e.g. If I select the range 1-Jan to 4-Feb and the maximum date present is 28-Jan, then it should take a sum of values (present in another column) for 28-Jan.

Re: SUM(VALUES) based on MAX of another value

agigliotti — Mon, 09 Oct 2023 15:26:26 GMT

Hi @nilesh_gawali ,

Maybe this:

Sum({< Date = {"$(=Date(Max(Floor(Date))))"}>} value )

I hope it can helps.

Best Regards

Re: SUM(VALUES) based on MAX of another value

Chanty4u — Wed, 11 Oct 2023 10:31:00 GMT

try this

Sum({<Date = {"=Date = Max(Date)"}>} Value)

Re: SUM(VALUES) based on MAX of another value

nilesh_gawali — Mon, 16 Oct 2023 12:39:07 GMT

Thank you @Chanty4u