topic Aggr with Max in App Development

Aggr with Max

lucasx15 — Wed, 25 Jan 2023 13:39:19 GMT

Hi all,

Kindly help me out in the below scenario,

I have a column in which I have the Section(the section numbers are just identifiers), CURRENT DAY AND THE TOTAL OF OCCUPIED BANKS IN EACH SECTION. I need to make the sum of these totals in an object, the total sum needs to be 314.

However, I thought about aggregating the total by section and current day. So I can keep up with each day. I made the following expression, however, it does not return the total value.

FirstSortedValue(TOTAL, Aggr(SUM(TOTAL),CD_SECTION,DT_CURENTDAY))

Re: Aggr with Max

vinieme12 — Thu, 26 Jan 2023 09:47:25 GMT

just use SUM()

=Sum(total) // by each dimension

or Sum(TOTAL total) // OVERALL totals

or Sum(TOTAL <CurrentDay> total) // Totals by CurrentDay

Re: Aggr with Max

lucasx15 — Thu, 26 Jan 2023 11:02:26 GMT

Thank you for helping, Vineeth !😁