Addition base on Year/Period

[#1]

Hello,

Plz I wanna add (Full Bal.) 2011 + (Full Bal.) 2012 =  (Bal. Subtract 2012 - 2013) 2012

same for the next then (Full Bal.) 2011 + 0 = (Bal. Subtract 2012 - 2013) 2011

How do I resolve this?

[petter]

It is hard to understand your explanation... sorry

[#3]

Ok,

please don't mind the name  (Bal. Subtract 2012-2013) its just the field name

Full. Ball @ 2011 = Bal. Subtract 2012-2013 @ 2011

and

Full. Bal @ 2011 - Full.Bal @ 2012 = (Bal. Subtract 2012-2013) @ 2012

and

Full. Bal @ 2012 - Full.Bal @ 2013 = (Bal. Subtract 2012-2013) @ 2013

and

Full. Bal @ 2013 - Full.Bal @ 2014 = (Bal. Subtract 2012-2013) @ 2014

and

Full. Bal @ 2014 - Full.Bal @ 2015 = (Bal. Subtract 2012-2013) @ 2015

[#4]

Yes this what I meant

[maxgro]

My guess is you want the values of previous year (row): you can use the above function.

[#6]

Picking above value in sum calculation give wrong answers. especially  on pivot table which am using

[petter]

If you have an application with test data to share it will be much easier for us to help you quickly.

[#8]

Ok, Find attached.

Thanks Petter