Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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:

http://help.sap.com/saphelp_nw04/helpdata/en/23/17f13a2f160f28e10000000a114084/content.htm

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

Thanks,

Venkat.

Former Member
Not what you were looking for? View more on this topic or Ask a question