topic Re: Year on Year Growth in App Development

Year on Year Growth

shwetagupta — Tue, 07 Jun 2016 10:47:22 GMT

Hi All,

Read many of the content on community but haven't got the solution,

I am calculating growth of this year to last year (2014 and 2015),

Current Year Sales= sum({< REPORT_YEAR = {"$(=Max(Year([DATE])))"}>} MRP_VALUE)

Previous Year Sales = sum({< REPORT_YEAR = {"$(=Max(Year([DATE]))-1)"}>} MRP_VALUE)

Problem is : In result Current year sales = Current +Previous year sales.

It is not giving me sum of the current year only !!!

i.e Whenever I make selection over year for eg: 2015 or 2014 it provide the correct result.

My all the dates lies in the single column

Can Anyone please suggest what is the problem and how can it be rectified.

sunny_talwar — Tue, 07 Jun 2016 12:06:04 GMT

How are DATE and REPORT_YEAR fields linked to each other?

shwetagupta — Tue, 07 Jun 2016 13:58:28 GMT

Hi Sunny T,

Thanks a lot for your this question.

Actually I was doing a blunder mistake while working which I noticed after your question, I picked up a wrong field name.

Now sorted ..

Thanks again for your time and Reply

sunny_talwar — Tue, 07 Jun 2016 14:08:15 GMT

Great,

Please mark the thread as closed.

Best,

Sunny