Hi
Im creating a dictionary and i need to use a few formulas which is easy enough, except that some of the formulas are quite long and go over the 1640 char limit. So I read thru a few things including knowledge base doc C2008073 and decide to split my formula into two and and have third formula which controls it
i.e.
formula 1
if field x = 1 then "Hello"
else if field x = 2 then "Bye"
.
.
else if field x = 23 then "See you later"
else "see next"
formula 2
if field x = 24 then "Hi"
else if field x = 25 then say "Goodbye"
.
.
else if field x = 50 then say "See you around"
formula c
if formula 1 = "see next"
then formula 2
else formula 1
now all of this seems straight forward but the problem is when i do this the dictionary doesnt seem able to reference formula 1 and 2 and i get a field not found error
is there some way i have to name the formulas ?
How do i reference these formulas from within the dictionary ?
any suggestions would be welcome
help
Im creating a dictionary and i need to use a few formulas which is easy enough, except that some of the formulas are quite long and go over the 1640 char limit. So I read thru a few things including knowledge base doc C2008073 and decide to split my formula into two and and have third formula which controls it
i.e.
formula 1
if field x = 1 then "Hello"
else if field x = 2 then "Bye"
.
.
else if field x = 23 then "See you later"
else "see next"
formula 2
if field x = 24 then "Hi"
else if field x = 25 then say "Goodbye"
.
.
else if field x = 50 then say "See you around"
formula c
if formula 1 = "see next"
then formula 2
else formula 1
now all of this seems straight forward but the problem is when i do this the dictionary doesnt seem able to reference formula 1 and 2 and i get a field not found error
is there some way i have to name the formulas ?
How do i reference these formulas from within the dictionary ?
any suggestions would be welcome
help