PDA

View Full Version : IF command, Case command, sort command


ABC123

Dannie Mogensen
11-14-2004, 09:05 AM
We are a small business located in Denmark investigating possibilities for using AlphaV.

Am I right when I observe that when we trying to create a calculated field, there can only be to levels of IF command IE: IF(....., IF(..) ,IF(...)). This also seems to be the case with CASE-command.

Is it also true that no sorting can be made base on a value in another linked file?

Regards
Dannie Mogensen

Selwyn Rabins
11-14-2004, 06:08 PM
I don't understand the question about sorting, but there is no limit to the number of IIf() functions that can be nested. The only limit is the length of an A5 expression.

However, even that limit is irrelevant because you can always create a UDF that allows unlimited complexity in your logic.