This is a newb type question and I really should know the answer to this but I am using CR v7 and I have a formula that uses nested ifs (or how I wish this version supported CASE statements). Based on the criteria of the if statements I would like to execute a block of code for each possibility. The question is, how can I use these multiple command lines in the if statements?
For example
if table1.id = 1 then
statement 1
statement 2
else
if table1.id = 2 then
statement 3
statement 4
etc....
When I try this approach I get an error about the remaining text not being a part of a string, number etc. When drop commands and execute the formula with single lines after the if statements it does not error out.
Any help would be greatly appreciated.
Thanks!
For example
if table1.id = 1 then
statement 1
statement 2
else
if table1.id = 2 then
statement 3
statement 4
etc....
When I try this approach I get an error about the remaining text not being a part of a string, number etc. When drop commands and execute the formula with single lines after the if statements it does not error out.
Any help would be greatly appreciated.
Thanks!