topic Cumulative Sum in App Development

Cumulative Sum

lg92 — Sat, 16 Nov 2024 17:24:49 GMT

Hi,

I have this table

YearDate Amount
2019 1000
2019 20000
2018 4550
2020 45480
2019 3200
2019 23320
2021 32780
2021 12370
2021 12300
2020 24890
2018 6580
2019 68750
2020 237890
2021 21330
2021 54560

I need to develp a KPI that calculate cumulative sum by years. if i filter year = 2020, the kpi sum 2018 + 2019 + 2020.

Thanks in advanced

Re: Cumulative Sum

Taoufiq_Zarra — Mon, 08 Mar 2021 10:17:00 GMT

@lg92 like ?

=sum({<YearDate={"<=$(=getfieldselections(YearDate))"}>} Amount)

example :

Re: Cumulative Sum

lg92 — Mon, 08 Mar 2021 11:27:29 GMT

This solution works only if i select one year. I need that works also if i don't select any year (in this case kpi sum 2018 +2019+2020+2021 as default).
anyway thank you

Re: Cumulative Sum

agigliotti — Mon, 08 Mar 2021 11:32:28 GMT

Hi @lg92 ,

Maybe this:

=Sum( {< YearDate = {"<=$(=Max(YearDate))"} >} Amount )

I hope it can help.

Best Regards

Re: Cumulative Sum

Taoufiq_Zarra — Mon, 08 Mar 2021 11:35:42 GMT

=sum({<YearDate={"<=$(=max(YearDate))"}>} Amount)