Occasional Contributor

Formula for cell value

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 ?

 Anaplan_WF.png

 

Thanks,

Satish.

1 REPLY 1
Highlighted
Occasional Contributor

Re: Formula for cell value

Hi Satish, 

 

 

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.

 

Best,
Joris.