on 10-08-2008 4:43 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.