topic Re: RangeSum Calculate Dynamic Cumulative in App Development

RangeSum Calculate Dynamic Cumulative

cristianozilz — Tue, 24 May 2022 14:43:52 GMT

I have a situation where I need to accumulate a dynamic amount through the script. Considering in this example an accumulation of 3 in 3 days.
I need to add the current day, with the next two days, and so on until the last record.

Something similar to using RangeSum (Above(MyField,0,3)). However, I need to do it in the script.

Re: RangeSum Calculate Dynamic Cumulative

brunobertels — Tue, 24 May 2022 15:34:43 GMT

may be like this

Load

RangeSum(Peek(Field), Peek(Field, -2), Peek(Field, -3)) as RangeSUM

Here you have to be careful about the load order : use order by Date desc ;

Re: RangeSum Calculate Dynamic Cumulative

cristianozilz — Tue, 24 May 2022 16:30:36 GMT

thank you very much for answering
i got it, but the only problem is that it's not a fixed range value.
There will be products that the interval will be, 3 other 2, another 15, it would have to be dynamic in some way

Re: RangeSum Calculate Dynamic Cumulative

brunobertels — Wed, 25 May 2022 07:01:05 GMT

so you can adapt the mesure with a if statement

if(Product ='product1',

RangeSum(Peek(Field), Peek(Field, -2), Peek(Field, -3)) ,

if(product ='Product2',

RangeSum(Peek(Field), Peek(Field, -2), Peek(Field, -3),Peek(Field, -4),...,Peek(Field, -15))

))

as RangeSUM

Re: RangeSum Calculate Dynamic Cumulative

cristianozilz — Wed, 25 May 2022 12:11:17 GMT

Good Morning,
Thank you very much for replying, I was able to assemble the command dynamically. it looked like this:

FOR a=1 to NoOfRows('RangeTab')
LET vLead = Peek('LeadProduto', $(a)-1, 'RangeTab');

SET vCommand = 'RangeSum([qtd]';
For b=1 to ($(vLead)-1)
LET vCommand = '$(vCommand), Peek([qtd], - $(b))';
Next
LET vCommand = '$(vCommand)) as RangeSum';
NEXT