In attached image i'm trying to get the highlighted GREEN of second column cell value into highlighted BLUE of first column cell.
What formula needs to write to achieve this ?
This could be something in the direction of:
IF ITEM(ListName) = ListName.Gross Revenue THEN Gross Revenue[SELECT: ListName.Total Contract] ELSE XYZ
where "ListName" represents the name of the list you are using for the contract elements and "XYZ" represents the formula that is currently already in place in the "Value" line item.