Adding Rows containing currency

[sb001]

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

[ppr (Peter)]

@ppr

Assign activity

[Ridwan_Satrio1 (Ridwan Satrio)]

error message : option strict…

[sb001]

@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?

[Ridwan_Satrio1 (Ridwan Satrio)]

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

[ppr (Peter)]

@Ridwan_Satrio1

So, I’m having a hard time finding out how to add up the rows

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

[Ridwan_Satrio1 (Ridwan Satrio)]

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

[ppr (Peter)]

Create a variable:

Use an assign activity done as here

And replace YourDataTableVar with the variable name of you datatable

@Ridwan_Satrio1

ci, a, d, v and “de-DE” and x

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:

@ppr

About the differen local number format following approach should work

[Ridwan_Satrio1 (Ridwan Satrio)]

how to fix it? can help me again?

[ppr (Peter)]

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

[Ridwan_Satrio1 (Ridwan Satrio)]

okey i got it, and how about it?

[ppr (Peter)]

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

[Ridwan_Satrio1 (Ridwan Satrio)]

i got it this error, why?

[ppr (Peter)]

we need to analyze it and mentioned the first anylsis steps for this.

@ppr

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

Thanks for supporting us by sharing the result with us

[Ridwan_Satrio1 (Ridwan Satrio)]

im so sorry im new in uipath, i feel happy for your help, thx.god bless

[ppr (Peter)]

for training help have a look here:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

[Ridwan_Satrio1 (Ridwan Satrio)]

the robot is always stop, but wait a sec

[Ridwan_Satrio1 (Ridwan Satrio)]

got it

how?

[ppr (Peter)]

As mentioned and part of default analysis, the internal value representation within the datatable is driving the convertion strategies, not the visuals from excel.

it looks that it has the default formatings and the decimal seperator / group seperator is confused.

Change the datatype of totalTA to Double

Use following LINQ

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