Replace values and remove duplicate

[Amit_Fernandes]

Hi,

Is there a formula to replace existing amount with current amount?, in example below i want to replace amount in Sum column to Sum TD amount. i:e - replace "8300000000" to "10590000000" and remove the Row when there is NULL amount in Sum column. 

RecordID	Company Name	Currency	Sum_TD Amount	Exchange Rate	TD Total	sum
1	India Private Limited	INR	8300000000	83.19	99771607.16
2	India Private Limited	INR	8300000000	83.19	99771607.16	10590000000

[caltang · Accepted solution]

This is one way to do it:

[Amit_Fernandes]

Thanks for quick response, Castor! I am afraid the amount might not be same every time, should I then replace with >= signs?

[binuacs · Accepted solution]

@Amit_Fernandes 

[caltang]

Then you should opt for @binuacs method. It is important to mention how dynamic you want because your question was more towards how. But I will ask for you to review the logic more thoroughly before concluding - are there any other factors?

[Amit_Fernandes]

Much appreciated. Thanks!