IN( ) Tests if a value is equal to a value in a list. Syntax IN(value, check1,..., checkN) Arguments value The value to test. The value can be a string, numeric, or date value. check1, ..., checkN The value or values to which to compare. Returns True if value is equal to one of the check values; returns false otherwise. Example The following example tests if New Haven, Baltimore, or Cooperstown are values in the city data field. If any one of the cities is in the data field, IN( ) returns true. IN([city], "New Haven", "Baltimore", "Cooperstown") The following example tests if 9/15/08 or 9/30/08 are values in the payDate data field. If you supply a literal date as an argument, you must include the time value, as shown in the following example: IN([payDate], "9/15/08 12:00 AM", "9/30/08 12:00 AM") The following example uses IN( ) in conjunction with the IF( ) function to test if Ships or Trains are values in the ProductLine data field. If Ships or Trains is a value in the field, the computed column displays Discontinued Item; otherwise, the product line value is displayed as it appears in the field. IF(IN([ProductLine], "Ships", "Trains"),"Discontinued Item", [ProductLine])
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy