Adding Rows containing currency

Help Studio
, ,
1

image
image249×593 4.44 KB

I have a variable that contains currency as below, and if I want to create a new variable that contains the total of the existing variables, what is the code?

2

Is there Separate variables for all the amounts?
And if it has one how is it storing all the amounts Please share screenshot?

3

no, just variabel to save this amount like this

image
image1077×171 4.43 KB

Amount=(code like the pic)

4
  1. Create one int32 variable of Transaction_amount_Total with Setting Default value to 0.
    2.Inside for each loop use assign activity Transaction_amount_Total=Transaction_Amount_Total+cdbl(mappingRow2(“Transaction Amount”).ToString)

Hope it helps.

Regards,
Saloni

5

oke let me try

6

Add System.Globalization to the imports (imports panel next to the Variable Panel)

Assign activity
LHS: totalTA | Int32
RHS:

(From d in YourDataTableVar.AsEnumerable
Let ci = New System.Globalization.CultureInfo("de-DE")
Let a = d("Transaction Amount").toString.Trim
Where int32.TryParse( a ,NumberStyles.Any, new CultureInfo("de-DE"), nothing )
Select v = int32.Parse(a,NumberStyles.Any,ci)).Sum(Function (x) x)

feel free to adopt the culture info and the datatype (e.g. shift to Double)

In case of trouble, same techniques for analyzing can be applied as similiar is described here for date time conversion issues

:ambulance: :sos: [FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

7

image
image1202×428 15.5 KB

how to setting default value to 0 ?

8

thx for your answer,
umm what mean of RHS and LHS? and what activity used in studio?

9

From variables Panel Which is located at bottom in Uipath Studio.

Screenshot (55)
Screenshot (55)792×237 7.72 KB

10

grafik

11

image
image1920×1080 239 KB

error message : option strict…

12

@Ridwan_Satrio1 I think there is misplaced characters in amount means instead of 4.680.000,00 it should be like 4,680,000.00 Right?

13

but the excel input file given in this case is like that. So, I’m having a hard time finding out how to add up the rows, what’s more, there’s a (-) sign in one of the numbers

14

as several options were suggested, which one did you tried and what was working or not working.

About the differen local number format following approach should work
grafik

15

umm im so sorry but i dont understand what mean of ci, a, d, v and “de-DE” and x in RHS

16

Create a variable:
grafik

Use an assign activity done as here
grafik

And replace YourDataTableVar with the variable name of you datatable

it is using LINQ within the statement, we do use these like local variables
[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum

OR

As also mentioned you can implement it within a for each row approach and parsing the string into an integer was mentioned here:

17

image
image701×360 18.9 KB

how to fix it? can help me again?

18

start analysis by using a single assign activity. Bring it out from the muliple assign.

19

okey i got it, and how about it?

image
image914×641 30 KB

20

set a breakpoint on the failling assign activity
debug and get paused
open immediate panel and type in:
dt_jurnal.Rows(0)(“Transaction Amount”).toString

we want to check the value within the datatable

Maybe the sum exceeds the maximum value of an int32 and we will change the datatype. But lets check out first the result from analysis above