2 Replies Latest reply on Dec 19, 2016 11:46 PM by vidya k

# how to calculate the budget by using two different years for same data

hi all,

Anyone can help me for calculation of table like

I have 2different years 2015,2016. I need to calculate the field like   "jan2016-dec2015,Feb2016-dec2015.......dec2016-dec2015."

I my project we need to perform calculation like Current Year- last year last month.

Can any Help to solve these problem.

Sorry I am unable to attach a workbook.

Thanks & regards,

Vidya

• ###### 1. Re: how to calculate the budget by using two different years for same data

Hi Vidya,

This will give us current year current month and last year last month.

if month([Order Date])%12=0

or (month(today())=month([Order Date]) and year(today())=year([Order Date])) then [Sales] END

thanks

sankar

• ###### 2. Re: how to calculate the budget by using two different years for same data

hi rajan,

I need to calculate JAN2016-Dec2015, Feb2016-Dec2015,MARCH2016-DEC2015 like these.

I tried with you formula but it only displaying last month data,

But my requirement is LAST YEAR LAST MONTH -- Current Year( every month)

thanks,

vidya