Get minimum value of a variable

Help
,
1

415/5000

good morning

-e used a “for each row” to detect the elements
-Then a “switch” to detect a certain element, in this case “costototal”
-which I put in a variable, through the “assign” activity
-this variable has 6 “6 numbers” data
-I would like to detect the smallest of them
-Put the term (if any?), in an activity “write line” and have the lowest number

thank you

image
image1440×900 88 KB

that’s the for each and the variable “costototal”
costottal
those are the data of the variable “costototal”, I would like to have a way of knowing the minimum value

2

If you only want the smallest value of a datatable column, you can just use Sort Activity and then get the value of the first row, dont need to For Each Row…

1 Like
3

Hi @borismh
Use Bala Rev Activities or use the dT Query

intminvalue=Convert.ToInt32(dt.AsEnumerable().Max(Function(row) row(“Column2”)))

Thanks
Ashwin S

4

Please read the question, he wants minimum and not maximum, also his value is not int32 he would be loosing precision there…

5

Hi @bcorrea

Sorry i didnt c that

intminvalue=Convert.ToInt32(dt.AsEnumerable().Min(Function(row) row(“Column2”)))
:slight_smile: :slight_smile:

Thanks
Ashwin S

6

still Convert.ToInt32 is not the answer… :wink:

7

@bcorrea
@AshwinS2

valor%20minimo
valor%20minimo1706×1302 123 KB

is that first I need certain excel values, since if I use that method that they tell me I would get the minimum value of the entire column, that’s why I use “for each” and then the “switch”

8

lol, that is a weird excel file :slight_smile: so create a variable of type List(Of Double) and in every loop you add the value in the collection, after you can get it like this:

Dim RowindexMin As Double = (From row As RowsFound In MyList.OrderBy(Function(x) x.LineValue) Select row.RowIndex).First
1 Like
9

@bcorrea
Sorry I didn’t understand, could you explain me

10

@bcorrea
excuse me could you explain to me, I get “expected end of expression”

11

Before the loop you assign: MyList = new List(Of Double)
Inside the loop you add the values using a Add To Collection activity.
After the end of loop you assign:
MySmallValue = MyList.ToArray.Min()

3 Likes
12

@bcorrea
thank you, it came out

1 Like
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.