428909_en-US

liliconcom

Reports conditional format rule in script

Hi,

I am trying to use a variable as value with reports and conditional formatting rules, please see the example below. I cannot get this to work. My best guess is to use eval() the get this work, but no success so far. Has anyone solved this kind of issue?

 

limit = 10;

Preferences(
 Conditional Formatting Rules(
  RuleSet(
   RuleName( "Red limit" ),
   GreaterThan( Value( limit ), Inclusive( 0 ), Format( Text Color( "Red" ) ) )
  )
 )
);

JMP version 15.2.0.

ScriptingRe: Reports conditional format rule in script

Thanks, great! It works, now I will try to understand why with the link you posted.

Re: Reports conditional format rule in script

Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute might help

 

limit = 10;

Eval(EvalExpr(Preferences(
 Conditional Formatting Rules(
  RuleSet(
   RuleName( "Red limit" ),
   GreaterThan( Value(Expr(limit)), Inclusive( 0 ), Format( Text Color( "Red" ) ) )
  )
 )
)));