Hi,
We are facing an issue in scenario of circular reference.
Please find the attached file. There are columns called OSBF, New, Comp and OSCF. And also there are the filters for selecting month and year.
The formula for OSCF = OSBF+New-Comp
The Formula for OSBF= Previous month value of OSCF.
We cannot get the correct OSBF value which is nothing but previous month of OSCF.
Could any one help in resolving this issue?
Thanks & Regards,
Karthikeyan.