Joined: 20 Feb 2009
Location: United States
Online Status: Offline
Posts: 66
Topic: Multiple IfThenElse Posted: 22 Nov 2013 at 7:36am
Hello all,
I need a help with the formula for multiple IFThenElse situation:
if answer = '1' then 'I am good'
else if answer = '2' then 'I am better'
else if answer = '3' then 'I am the best'
else if.....
end if;
it is working if students answer is only one but sometimes the answer can be 1 and 2 or 1 and 3 or 1 and 3 etc.
what do I do?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 22 Nov 2013 at 10:16am
if this is all on the same row you can concatenate several if-then statements.
(if {field} = 1 Then "I am good " ) + (If {field} = 2 Then "I am better ") + (If {field} = 3 Then "I am the best ")
If this is evaluating multiple rows than you need to use shared variables to concantentate the strings from row to row and then they can be displayed in the a footer (group or report)
If you have NULLs you need to set the formual to use default values for Nulls
If you have only one field 'Answer' with a single value then you can't write 'IF' statement using 'AND' because it always go in 'False' state and you will not get any results.
If you have multipul fields like 'ANSWER1',ANSWER2,ANSWER3' then it is possible to use conditional statement using 'and'.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
