Skip to Content
0
Former Member
Jun 15, 2011 at 10:28 PM

Using If Else on multiple fields

28 Views

Is there a way to create an object in a universe that is based off four other fields? For example, I want to have a field that can have four different values -- A, B, C, D. It will be a string format. The value that populates is based off upto four other existing string fields. Using basic If Else statement, it would look like this:

If

Field1<>"Z" Then "A"

Else

If Field1="Z" AND Field2<>"Z" Then "B"

Else

If Field1="Z" AND Field2="Z" AND Field3<>"Z" Then "C"

Else

If Field1="Z" AND Field2="Z" AND Field3="Z" AND Field4<>"Z" Then "D"

Is this possible within Designer? It's built off SAP BW. If not, what would be the best way to go about it.Thanks.