I have two line items in my module. The first value in the first line item is picked up from an another module, but the second value is first value of second line item and so on. My second line item is a product of first with some number (x)
When I use Yield = Starting Yield Coupon * X - I get a circular referencing warning error. I have used the forumla below for "Starting Yield Coupon"
IF Period.Coupon = 1 THEN Rates.Base Yield Coupon[LOOKUP: Period.Previous] ELSE Yield[LOOKUP: Period.Previous]
Where "Previous" is a property to identify previous value and "Coupon" to identify the first value.
Yes, you got the logic correct but I think the piece you missed out was the initialization. The first value of the first list (in column 1) is taken from another source. I am attaching the logic in Excel for reference.