7 Replies Latest reply on Nov 27, 2016 4:22 PM by Shesil Parmar

# % differernce between two months

Hi all

Been scratching my head since morning but couldn’t get it right.

So I want basically a percentage difference between current month and previous month, Month is controlled by a parameter, so for example

If someone select month 3 then it should change current month from selected 3 month minus previous month , if selected 6

Then most current month from selected 6 month minus previous month , and same goes for 12 month – if selected.

Hope I’m not confusing ..

• ###### 1. Re: % differernce between two months

Hello Shesil Parmar,

Let me know if this is what you were looking for

• ###### 2. Re: % differernce between two months

Thanks Lénaïc Riédinger, but this is not exactly i m looking for, as mentioned above i need difference between % value for the selected month from month parameter and any their previous month

• ###### 3. Re: % differernce between two months

Hi Sheshi,

If you sort the month(1) column in descending order, your calculation will be left to Sept 2016 - Jul 2016. Is this correct understanding?

• ###### 4. Re: % differernce between two months

Sample has July, August, September which are 7th, 8th and 9th months.

The month selector has 3 options : 3, 6, 12 which correspond to march, june and december.

When user selects 3 what is expected to happen?

Does it pick third month : March then pick previous month February and then compute the difference in AABB between February and July, August and September?

• ###### 5. Re: % differernce between two months

thanks sujay for looking into this.. sorting month should not change any calculation

• ###### 6. Re: % differernce between two months

Hi Bora Beran and Sujay Paranjpe the data are from Jan 2015,

so if the user select 3 from month parameter in November 16 for example than 3 difference should appear for selected unique id col. (ie. 101 , 109 ) for start point col. (it should do calculation like Oct16 minus Sept16,  Sept16 minus Aug16 and Aug16 - July16, and if next month(Dec 16) if user select 3 from month parameter than Nov16 minus Oct16,  Oct16 minus Sept16 and Sept16 - Aug16, - same goes for 6 and 12 months if selected from parameter control.

i have attached another workbook - i think formula in date looks incorrect and spreadsheet (how the result look like )

thank you so much.

• ###### 7. Re: % differernce between two months

any help ??