Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Gysbert,
Thanks for the solution,
I am getting an absurd error when using this logic. All my cumulative sales are converted into monthly sales except for year 2014 7th month. It is showing monthly values same as cumulative values. however when I checked it into excel its working fine.
Please find attached the sample file.
Please help.
Regards,
Sanjay
Your data for this Year month are the same:
Hi Robert,
The data for this year month has been calculated by the formula. This is exactly the problem which we are facing. we have cumulative data and we are calculating monthly value out of it. but for this particular month it is showing same value. i have no clue Y?
What are your expected values then?