topic Re: Cumulative calculations in crosstable or charts - with selected periods in App Development

Cumulative calculations in crosstable or charts - with selected periods

markvandermeij7 — Sat, 16 Nov 2024 20:50:12 GMT

We have a weekly revenue;

We want to select 1 or more periods.

Both periods need to show correct revenue. This is not working.

We're not looking to use an "as-of" table, as this would complicate selection options.

Please see the screenshot below.
Formula such as below do not work.

sum({ <Year={"=$(=Max(Year))"},SEQ={"<=$(=Max(SEQ))"} ,YearWeek=>}Value ) (Works in textbox!)

AGGR( sum(Total { <Year={"=$(=Max(Year))"},SEQ={"<=$(=Max(SEQ))"} ,YearWeek=>}Value ) ,YearWeek )

Re: Cumulative calculations in crosstable or charts - with selected periods

sunny_talwar — Mon, 20 May 2019 11:48:19 GMT

Try this

RangeSum(Above(Sum({<Year = {"$(=Max(Year))"}, SEQ = {"<=$(=Max(SEQ))"}, YearWeek>} Value), 0, RowNo())) * Avg({<Year = {"$(=Max(Year))"}, SEQ = {"<=$(=Max(SEQ))"}>} 1)

Re: Cumulative calculations in crosstable or charts - with selected periods

markvandermeij7 — Mon, 20 May 2019 12:24:44 GMT

Thanks! That most certainly fixes it for me!