Nested IF statements in Crystal.
Posted on 2005-03-28
I need to setup a formula in which I need to first check to see if a value is within a given range it will then perform some parsing and determine if the value is within another range. If it is, I need to spit the value out, otherwise I need to return zero. Please trust me on the logic I need to perform, I just really need to know the syntax of how to perform something like the following in Crystal.
IF (accountID in [1 to 10]) THEN
companyNum = Right(accountID, 2)
IF (companyNum = previouslyDefinedValue) THEN
Thank you for your help