Dear RPA Developer,
Need your advise how to multiply if value reference is correct
Sample
Transaction Amount |
DR CR FLAG |
New value |
1,000.00 |
Credit |
IF column E= Credit then column D*-1 |
10,890.33 |
Credit |
|
10,890.33 |
Credit |
|
1,000.00 |
Credit |
|
1,613,607.00 |
Debit |
IF column E= Debit then column D*1 |
Expected i need create new value to
-1,000.00
1,613,607.00
i have use activity
1 read csv file.
2 build data table
3 for each row * to build new value
4 add data row
5 write range
Thank you so much.
Srini84
(Srinivas)
2
@pjaiphak
Check below post for your reference
Hope this helps you
Thanks