topic Re: Next 11 months cumulative sum in App Development

Next 11 months cumulative sum

miskin_m — Sat, 16 Mar 2019 15:35:51 GMT

Hi All,

Need help to calculate next 11 cumulative sum. I did not want to use the rangesum below since it is restricted to the dimension value in chart.

EG: if Apr 17 then it shld be from Apr 17 to Feb 18.

Need solution at the back end. I have already used the as of table but it works with rolling last month.

Regards

Anil_Babu_Samineni — Sat, 16 Mar 2019 16:00:36 GMT

If you select Apr 17 - How you are getting data in script? BTW, You are seeing those affections in design. Why are you looking in script.

miskin_m — Sat, 16 Mar 2019 16:32:01 GMT

Hw u will do it at front end. I need the 13 months in the chart and for each month it shld calculate its respective next 11 month sales.

Anil_Babu_Samineni — Mon, 18 Mar 2019 09:33:01 GMT

If Jan-18 selected, What is the expected result? And How much data you have for forecast, if any?