topic Re: How to stop future month prediction in Cumulative sum? in App Development

How to stop future month prediction in Cumulative sum?

qs123 — Sat, 16 Nov 2024 20:04:47 GMT

Hi Guys,

I have two table

Showing Actual Revenue from Jan 2019 to Sep 2019
Showing Predicted Revenue from Jan 2019 to Dec 2019

I am trying to create cumulative bar chart to show how much we were suppose to earn and how much we have actually earned and how much more to achieve?

I am using following expressions

For Cumulative Revenue = rangesum( above( sum(Revenue),0,rowno()))
For Cumulative Target = rangesum( above( sum(Target),0,rowno()))

This how my chart looks like...

Here is the problem is...

I do not have Revenue data for (Oct, Nov & Dec) Still the chart is projecting those value. How do I stop it doing so?

Please refer to the attached sample QVF application and Sample Data.

Thank you

Re: How to stop future month prediction in Cumulative sum?

lironbaram — Mon, 16 Sep 2019 05:52:23 GMT

have a look at the attach example

Re: How to stop future month prediction in Cumulative sum?

sunny_talwar — Mon, 16 Sep 2019 11:11:22 GMT

You can also try like this... but this might become a problem if you happen to have a month without Revenue in your actual data

If(Sum(Revenue) <> 0, RangeSum(Above(Sum(Revenue), 0, RowNo())))

Re: How to stop future month prediction in Cumulative sum?

qs123 — Fri, 20 Sep 2019 04:36:45 GMT

Thank you Sunny. It worked.

Re: How to stop future month prediction in Cumulative sum?

rafsan — Wed, 23 Mar 2022 22:32:05 GMT

Worked like magic. Thank you, Sunny. Your comments have always been helpful.