Skip to Content

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

if.. then... else

need to use multiple in a variable in webi, how do i??

for example

=IF(math([NT];"1.1.1.2.05*");"camp1";if([NT] ="1.1.1.2.05.01.06";"camp2";"camp3"))

in this way it i do not correctly returns the values, as does not display the "camp2" because in the first condition already answered as do i use if ... then ... else ... if ... then .. else???

thank's

Edited by: gzofera on Oct 8, 2008 5:44 PM

replied

Hi,

One can view your condition as some form of hierarchy... then in this case, you would need to start with the deepest level first and then move up the hierarchy when checking the condition in your nested "if" statements i.e the first if statement should almost be in this order camp3, camp2 then camp1.

Hope this helps

Jacques

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question