### Find Max, Min, Average value from a DataTable UiPath

In the business automation process we always use DataTable.

Assuming we are working with some marks of a student or any other financial calculations of any process.

Let’s see the implementation of finding max min and average values from a DataTable.

**Step1: Drag and Drop a Build DataTable Activity and build a datatable as shown below:**

**Step2: As we have the datatable ready now we need to get the max value from it. **

Use the below-mentioned Syntax to get the maximum value from the DataTable:

**DT.AsEnumerable().Max(Function(row) cint(row(“ColumnName”)))**

Create a variable which can hold this max value as shown below:

Here in the place of columnName entire the column for which you want to calculate Max Value.

**Step3: Now we will see how we can calculate the minimum value from the datatable.**

Use the below mentioned syntax to get the minimum value from DataTable:

**DT.AsEnumerable().Min(Function(row) cint(row(“ColumnName”)))**

Create a variable which can hold this minimum value as shown below:

**Step4: Finally, we will see how to get the average value from the datatable.**

Use the below syntax to get the average value from DataTable:

**DT.AsEnumerable().Average(Function(row) cint(row(“ColumnName”)))**

Create a variable which can hold this average value as shown below:

This is how you calculate the max min and average values from a DataTable using UiPath.

Now let’s see the outputs of these Assign activity values one after the other as shown below:

**The maximum value from DataTable is shown below:**

**The minimum value from DataTable as shown below:**

**The average value from DataTable as shown below:**

This task will be useful while you are working on a business process that is related to finance or any process which has numbers calculation.