How do i average a column to become one number only

[preeti5]

The column in grey how do i make it into just 1 number like in excel you can do that…how can i do this in knime?

[armingrudd]

Hi @preeti5,

If you need the average in a single cell use the GroupBy node and add the column(s) in one of the aggregation tabs with “Mean” method.

If you need to retain rows, use COL_MEAN() function in Math Formula or Math Formula (Multi Column) nodes.