Average of last 3 rows

[RPA_Path]

Hi, I am trying to get the the average of the last 3 rows with AddHeaders on. How can this be accomplish?

[lakshman (Ganta lakshman)]

@RPA_Path

1. Use Read Range activity to read the data from Excel file and it will give output as DataTable. Let’s say dtInput.

2. And then try below expression.

          int_avg = dtInput.AsEnumerable().Skip(dtInput.Rows.Count-3).Take(3).Average(Function(row) cint(row("Columnname").ToString))

[RPA_Path]

Thank you. How do I round up and make sure there’s only one number after the decimal?

[ushu (Usha kiranmai)]

@RPA_Path Take assign activity and use the below exp

Variable Type Double Output = Math.Round(Input,1)

• Input is the variable that contains the decimal value
• Output variable contains the single value after decimal

[Yoichi]

Hi,

If you want to round precisely, I recommend to use MdipointRounding.AwayFromZero, as the following.

Math.Round(dt.AsEnumerable.Skip(dt.RowCount-3).Average(Function(r) Double.Parse(r("yourColumnName").ToString())),1,System.MidpointRounding.AwayFromZero)

Regards,