Referencing same line item of prev row

Hi,

 

I am facing issue in trying to reference the same item of prev row. For example,

This is the Excel formula for a line item ‘Calendar Month’ :

 

 IF Calendar month of prev row = 12 THEN 1 ELSE Calendar month of prev row + 1

 

Has anyone faced similar issue? The Else part of the formula gives circular reference.

 

Answers