topic Reports conditional format rule in script in Discussions

Reports conditional format rule in script

jueefo — Fri, 09 Jun 2023 18:03:20 GMT

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.

Re: Reports conditional format rule in script

jthi — Thu, 21 Oct 2021 09:16:45 GMT

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

Re: Reports conditional format rule in script

jueefo — Thu, 21 Oct 2021 09:51:41 GMT

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