How to find average value of column Except last row from column

[shaik.muktharvalli1 (shaik muktharvalli)]

How to find average value of column Except last row from column

thanks
shaik

[prasanna_thor]

@shaik.muktharvalli1

How to find average value of column Except last row from column

avgValue = (From row In DataTableName.AsEnumerable().Take(rowCount - 1)
Select Convert.ToDouble(row(“YourColumnName”))).Average()

Use this in assign activity… avgValue should be integer type

[lrtetala (Lakshman Reddy)]

Hi @shaik.muktharvalli1

Try this

dt.AsEnumerable().Take(dt.Rows.Count - 1).Average(Function(row) If(IsNumeric(row("Column1")), CDbl(row("Column1")), 0))

Cheers!!