INVOKE CODE ERROR CORRECTION

[Krishan_Rapswal]

((IsNothing(x(“Description”)) OrElse String.IsNullOrEmpty(x(“Description”).ToString.Trim)) AndAlso x(“Description”).ToString.Contains(“TDS”))
(CurrentRow.Field(Of Double)(“Amount”)* -1)
(CurrentRow.Field(Of Double)(“SIGN”)* 10)
(CurrentRow.Field(Of Double)(“PERCENT”) - CurrentRow.Field(Of Double)(“SIGN”))
(Datediff(DateInterval.Day,DateTime.ParseExact(CurrentRow(1).ToString,{“dd.MM.yyyy hh:mm:ss”,“MM/dd/yyyy hh:mm:ss”,“MM-dd-yyyy”,“dd-MM-yyyy”},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None),now).ToString)

PLEASE HELP IN THIS INVOKE CODE

[Yoichi]

Hi,

For now, can you try to modify argument name and type as the following?

Regards,

[Krishan_Rapswal]

Still getting error

[Yoichi]

@Krishan_Rapswal

((IsNothing(x(“Description”)) OrElse String.IsNullOrEmpty(x(“Description”).ToString.Trim)) AndAlso x(“Description”).ToString.Contains(“TDS”))
(CurrentRow.Field(Of Double)(“Amount”)* -1)
(CurrentRow.Field(Of Double)(“SIGN”)* 10)
(CurrentRow.Field(Of Double)(“PERCENT”) - CurrentRow.Field(Of Double)(“SIGN”))
(Datediff(DateInterval.Day,DateTime.ParseExact(CurrentRow(1).ToString,{“dd.MM.yyyy hh:mm:ss”,“MM/dd/yyyy hh:mm:ss”,“MM-dd-yyyy”,“dd-MM-yyyy”},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None),now).ToString)

Can you share what you expect by this code? It seems wrong syntax.

Regards,

[Krishan_Rapswal]

RPA.xlsx (15.3 KB)

From “Sheet 1” to “Final Sheet”
Using INVOKE CODE

[arivu96 (Arivazhagan A)]

Hi @Krishan_Rapswal,
it seems syntax is wrong. can you tell me what you are expecting by using this syntax.

Regards,
Arivu

[Krishan_Rapswal]

I Have to change in excel using invoke code

RPA.xlsx (15.3 KB)

INPUT - SHEET 1

OUTPUT - FINAL

[Krishan_Rapswal]

I am using Assign value in INVOKE CODE

[Eric_Wong_Test (Eric Wong)]

Sample.xaml (11.0 KB)
Please try but don’t know what the logic is with a due date

[Krishan_Rapswal]

Can we short this method using if condition

[Eric_Wong_Test (Eric Wong)]

Yes, you can.

[Krishan_Rapswal]

what i am doing wrong

[Krishan_Rapswal]

i want to loop Invoke Code what i am doing

[yikwen.goo]

1. Your If condition does not have a condition specified. It’s just “If” followed by a set of assignments. Under what condition do you want row(“SIGN”) = “Amount”?
2. “Amount”*(-1) is wrong because “Amount” is a String. I presume you want “Amount” to be a variable containing some number.

Could you describe in words what you plan to do for each row in dt_AsEnumerable?

[Krishan_Rapswal]

Sample.xaml (11.2 KB)

I Have to short this Invoke Code Using LOOPING