IN( )The following example tests if New Haven, Baltimore, or Cooperstown are values in the city field. If any one of the cities is in the field, IN( ) returns true.The following example uses IN( ) in conjunction with the IF( ) function to test if Ships or Trains are values in the ProductLine field. If Ships or Trains is a value in the field, display Discontinued Item; otherwise, display the product line value as it appears in the field.IF(IN([ProductLine], "Ships", "Trains"),"Discontinued Item", [ProductLine])
|
|
Copyright Actuate Corporation 2012 |