Skip to main content
Question

Dependency Circular Issue

  • July 22, 2025
  • 1 reply
  • 90 views

Forum|alt.badge.img+5

Hi everyone,

 

I am working a logic where I need to Input P&L interest value line based on calculation which will refer to P&L Interest line again. 

 

Below is example of same with Excel formula, how do I avoid error on P&L Interest line. 

 

 

Thanks.

1 reply

CDALMAY
Master Helper
Forum|alt.badge.img+14
  • Master Helper
  • July 22, 2025

Hey ​@Apurv ,

You could achieve this with PREVIOUSBASE() , here is some documentation on how it set it up :
 


Let me know if you need a detailed walk through

Hope this helps