Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0411

...

A more detailed nested example is available below. See Example - Stock Quotes below.

D s
snippetSyntax

In the following, if the test expression evaluates to true, the true_expression is executed. Otherwise, the false_expression is executed.

...

This parameter contains the expression to evaluate. This expression must resolve to a Boolean (true or false) value.

D s
snippetusage

Required?Data TypeExample Value
YesString (expression that evaluates to true or false(LastName == 'Mouse' && FirstName == 'Mickey')

true_expression, false_expression

...

  • A true expression is required. You can insert a blank expression ( "").
  • If a false expression is not provided, false results yield a value of false.

D s
snippetusage

Required?Data TypeExample Value
YesString (expression)

See examples below.

D s
snippetExamples

Example - Basic Usage

...

Info

NOTE: For a larger dataset, you might maintain your buy, sell, and hold evaluations for each stock in a separate reference dataset that you join to the source dataset before performing comparisons between column values. See Join Page.

To assist in evaluation, you might first want to create columns that contain the cost (Basis) and the current value (CurrentValue) for each stock:

...