Is there a way to color a column box nested in a col span box dynamically? For example, say I could have any number of rows and I want to only color values over 80 red, is this possible like it is for a data table?
I have included the code I am using to color a data table and show it in a results window. As well, I have attached a sample of what my spanned column table would look like. I would like to do the same coloring I’m doing to the data table on the spanned column table in the report window. Please help, thanks!
list = {12.5,55,23,99,87.6,77};
dt = New Table( "TEST",
Add Rows( 6 ),
New Column( "A", Numeric, "Continuous", Format( "Best", 12 ), Set Values( list ) ),
);
fail = dt << Get Rows Where( as column(column(dt,"A")) > 80);
Column(dt, "A") << color cells(Red, fail);
nw3 = New Window( "Results",
Table Box(
String Col Box( "Time", {"2","4","8","16","32","48"} ),
Col Span Box(
"REF",
Number Col Box( "CV", {12.5,55,23,99,87.6,77}),
Number Col Box( "Mean", {12.5,55,23,24,87.6,77})
),
Col Span Box(
"TEST",
Number Col Box( "CV", {12.5,99,23,24,87.6,99}),
Number Col Box( "Mean", {12.5,55,23,24,87.6,77})
)
),
dt << Get As Report()
);
Close(dt, nosave);
