cancel
Showing results for 
Search instead for 
Did you mean: 

if.. then... else

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

OK friend thank you for help. More is that AI is the problem ... i this way ... i have the camp3, camp2, camp1 and more at camp1 acumulue the values that are beyond those who have been satisfied if the camp2 and camp3 know how can i resolve?

thank you

Former Member
0 Kudos

i understand that in my case the IFS are this way

if (condition; true; if (condition; true; if ......

a within the other is to do if outside ...

Answers (0)