RangeSum(Above( performance issue, how can it be fixed?

Davide_Azzolini — Sat, 16 Nov 2024 06:16:26 GMT

Hi,

I have a performance issue using RangeSum.

Here the expression:

RangeSum(Above(
Sum({$<Year = {$(=If(GetSelectedCount(Year) = 0 AND GetSelectedCount(MonthYear)=0, max(Year), Concat(Year, ',')))}>} value_fact)
, 0, RowNo()))

When I change filters, charts and tables takes too long to load the filtered data.

I tried to put RangeSum into the script, but it isn't what i want, I need a runtime calculation of that column.

The question is:

Do I need to upgrade my server to make rangesum faster?

Thanks to all, Davide.

Re: RangeSum(Above( performance issue, how can it be fixed?

sunny_talwar — Fri, 22 Mar 2019 11:11:07 GMT

Use The As Of Table instead

Re: RangeSum(Above( performance issue, how can it be fixed?

Davide_Azzolini — Fri, 22 Mar 2019 13:19:34 GMT

Very useful, thanks!

topic Re: RangeSum(Above( performance issue, how can it be fixed? in App Development

RangeSum(Above( performance issue, how can it be fixed?

Re: RangeSum(Above( performance issue, how can it be fixed?

Re: RangeSum(Above( performance issue, how can it be fixed?