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 |
Thanks for quick response, Castor! I am afraid the amount might not be same every time, should I then replace with >= signs?
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?
Much appreciated. Thanks!