Hello I am quite new to UiPath, so I was wondering is it possible to show a message box, stating the total invoice values? Values were extracted from PDF.
Welcome to uipath community.
Yes ,you can use message box
here totalinvoicevalue is the variable
@sangeethaneelavannan1 I am able to do that part, but is there a way to add all the values from the “totalinvoicevalues”? Currently, it will show each value 1 by 1
Assign totalvalues=totalvalues+totalinvoicevalues inside and after all iterations use the message box to show total values
@sangeethaneelavannan1 is this how it should be?
I have tried this method, but it seems like it is not adding the amount
If the value is in string format you need to change it to integer by using CInt.
Could not see your image
Yes As Rahul said you need to change it to int
Yes the values is in string format as after this activity, I have to extract the information to an excel file.
I have tried the Cint(totalvalues)+Cint(totalinvoicevalues)
The amountdue contains all the values extracted from the PDF
Just to add on, AmountDue is in string format
Totalinvoice should be an integer datatype and you need to give,
in the message box.
What is the datatype of totalInvoice? it should be int and total invoice should be in message box
There is an error if I were to run this program.
I am unable to chance the AmountDue to int as it will affect the extraction of data to csv
There is 9 values in “AmountDue”
Can we have a screenshot of full workflow?
This is the error that popped up
@how2awpp Try this cbdl(AmountDue) or remove the space in AmountDue
Amountdue.replace(" ",string. Empty)
You have space before 86 and it need to be removed.
Is it resolved???
If there are spaces you can use Trim method to remove it and then use CInt to convert to integer.