Skip to Content
Former Member
Nov 01, 2007 at 04:59 PM

How to calculate IF - THEN - ELSE condition in BEx Reports ??


Hi all,

I have a column called Class and depending on it's values I want to assign a value into a NEW column 'Owner Class' (It is not from any InfoObject) like the following:

If Class = 111ABC OR 111DFE OR 111PQRS OR 1111XYZ

then Owner Class = ABCD.

If Class = 222ABC OR 234DFE OR 333PQRS OR 345XYZ

then Owner Class = PQRS.


I have looked at the following 'boolean operators in formula' and it will not work in this case:

How could I accomplish my task at <b>Workbook</b> level, PLEASE ???