Multiplication based on certain conditions

Help Activities
, ,
1

Hello Everyone,

I am new to using this UIPath software and my first post to the community for help!

I am trying to automate a scenario where I need to multiply a column based on certain conditions.

For example, these are the conditions I need to check:

If the current value < 2000 multiply by 5
else if the current value >= 2000 multiply by 6
else if the current value > = 3000 multiply by 7
else if the current value >=4000 multiply by8
else if the current value >=5000 multiply by 9

Can anyone suggest a better solution to automate this scenario?

I am grateful to you!

Best Regards,
Iram Arshad

2

Hi,

Can you try the following?

img20211231-1
img20211231-1771×480 18.5 KB 

arrInt ={2000,3000,4000,5000}
result = cuurentValue*(5+arrInt.Count(Function(i) cuurentValue>=i))

or
result = someValue*(5+arrInt.Count(Function(i) cuurentValue>=i))

Regards,

4

I am trying to following your code but from where this “i” comes?

5

Hi,

i is anonymous argument of Linq expression.

The following document might help you.

Regards,