Skip to Content
0
Former Member
Jul 22, 2009 at 01:39 AM

Max or Sum a Row (Across Multiple Columns)

886 Views

Hi There I need to get the sum or maximum for a row across multiple columns.

Col1      Col2      Col3      Col4       Col5      Max
   6         2         4          3         4        6

For the above table I want to be able to get the maximum value for the row, across columns 1 to 5. So the formula (in Excel) would look like "=Max(Col1, Col2, Col3, Col4, Col5)" and I can't figure out how to do this in Webi.

Any help would be appreciated.

Regards,

Todd.