• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part: V Appendices > Logical Functions

Logical Functions

These functions are described in Hour 8, “More on Calculations and Functions.” They are presented here for completeness without the explanations that appear in Hour 8.

Table B.6. Logical Functions
FunctionResult
Case (test1;result1{;test2; result2;defaultResult...}))Any type.
Choose (test;result0{;result1; result2...})Text, number, date, time, timestamp, or container.
Evaluate (expression{;[field1; field2;field3;...]})Text, number, date, time, timestamp, or container.
EvaluationError (expression)Number
GetField (fieldName)Text, number, date, time, timestamp, or container.
If (test;result1;result2)Text, number, date, time, timestamp, or container.
IsEmpty (field)Number. Returns 0 if the field contains anything; 1 if it is empty, a table is missing, or it otherwise cannot be evaluated.
IsValid (field)Number. Returns 1 if it is valid, 0 in all other cases (see IsEmpty).
IsValidExpression (expression)Number. Returns 1 if expression is valid, 0 in all other cases.
Let ({[}var1=expression1 {;var2=expression2...]}; calculation)Text, number, date, time, timestamp, or container.
Lookup (sourceField {;failExpression})Text, number, date, time, timestamp, or container.
LookupNext (sourceField; lower/higherFlag)Text, number, date, time, timestamp, or container.
Quote (text)Returns text surrounded by quotes.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint