Business Objects - WebIntelligence IF Formula Syntax
Hello,
I would like to understand how to do a nested if statement in Business Objects Web Intelligence. A standard if works fine - e.g.:
=If([Field1]="Yes";1;0)
However, I have been unable to do a nested if - e.g.
=If([Field1]="Yes"; If([Field2]="2007"; 1 ; 2 ) ; 3 )
In the scenario above we are saying that if field1 = yes then it is a 1 (if field 2 also equals 2007) or a 2 otherwise, otherwise it is a 3 (i.e. if we have a no).
I have used a pseudo code example for simplicity - would much appreciate some urgent help on this including exact syntax on how to do the example above as a nested if using proper WebI BusObjects formula syntax.
Kind Regards,
Raheel
I would like to understand how to do a nested if statement in Business Objects Web Intelligence. A standard if works fine - e.g.:
=If([Field1]="Yes";1;0)
However, I have been unable to do a nested if - e.g.
=If([Field1]="Yes"; If([Field2]="2007"; 1 ; 2 ) ; 3 )
In the scenario above we are saying that if field1 = yes then it is a 1 (if field 2 also equals 2007) or a 2 otherwise, otherwise it is a 3 (i.e. if we have a no).
I have used a pseudo code example for simplicity - would much appreciate some urgent help on this including exact syntax on how to do the example above as a nested if using proper WebI BusObjects formula syntax.
Kind Regards,
Raheel
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.