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.