simple case

This macro construct is the template for a simple case, including the case, when, then, else, and end functions. Note that this macro construct is only supported in DQM mode.

Syntax

CASE <expression> WHEN <literal> THEN <expression> [ELSE 
<expression>] END

Example

#CASE prompt('pDateRange','token') WHEN 'Current Week' THEN '[PR 
Current Week]' ELSE '[PR Prior Week]' END#

Result

[PR Current Week]