osman.deveci
New Member
Hi,
Can someone help me with the following:
I have to calculate the difference between "Provisioned" and "Invoice amount" as seen below and create a new column named "difference".
I have put all data into a data collection stage and then calculated the difference of all rows one by one creating a loop. This is what I have in my collection after doing it:
The only remaining thing to do is putting the difference back into excel. When I try using write collection action, I get the error: "the collection has no current row".
Can someone help me how I can put the differences back into excel?
Thank you in advance!
Kind regards,
Osman
Can someone help me with the following:
I have to calculate the difference between "Provisioned" and "Invoice amount" as seen below and create a new column named "difference".
I have put all data into a data collection stage and then calculated the difference of all rows one by one creating a loop. This is what I have in my collection after doing it:
The only remaining thing to do is putting the difference back into excel. When I try using write collection action, I get the error: "the collection has no current row".
Can someone help me how I can put the differences back into excel?
Thank you in advance!
Kind regards,
Osman