Reports conditional format rule in script

[#1]

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.

[#2 · Accepted solution]

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" ) ) )
		)
	)
)));

[#3]

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