Anyone have any thoughts on this one. With my newfound know...

[Guest]

benjamin.maxwell:

 

Is there a way for me to see the green traffic light in RECAP 1010 where I am trying to combine the length of the Jaguar and BMW

 

 

Try using column numbers on your RECAP:

 

TABLE FILE CAR

SUM

LENGTH

COMPUTE TL1/A100 = IF LENGTH GT 500 THEN '<span style="color : green";> &|#x1F311; </span>' ELSE

IF LENGTH LT 500 THEN '<span style="color : red";> &|#x1F311; </span>'; AS ''

FOR CAR

-*

'JAGUAR' AS 'JAGUAR' LABEL R0010 OVER

'BMW' AS 'BMW' LABEL R0020 OVER

-*

RECAP R1000 = R0010; AS 'Jaguar' OVER

-*

RECAP R1010(1) = R0010+R0020; AS 'Jaguar and BMW' OVER

RECAP R1010(2) = IF R1010(1) GT 500 THEN '<span style="color : green";> &|#x1F311; </span>' ELSE

IF R1010(1) LT 500 THEN '<span style="color : red";> &|#x1F311; </span>';

ON TABLE SET PAGE-NUM NOLEAD

ON TABLE SET ASNAMES ON

ON TABLE NOTOTAL

ON TABLE PCHOLD FORMAT HTML

ON TABLE SET HTMLEMBEDIMG ON

ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *

INCLUDE=IBFS:/WFC/Repository/aFolder/code/stylesheets/warm.sty, $

ENDSTYLE

END

[Ben Maxwell]

Anyone have any thoughts on this one. With my newfound knowledge of traffic lights, I am now trying to apply them into a report written in FML.

Is there a way for me to see the green traffic light in RECAP 1010 where I am trying to combine the length of the Jaguar and BMW

Code :

TABLE FILE CAR

SUM

CAR.SPECS.LENGTH

COMPUTE TL1/A100 = IF CAR.SPECS.LENGTH GT 500 THEN '<span style="color : green";> &|#x1F311; </span>' ELSE

IF CAR.SPECS.LENGTH LT 500 THEN '<span style="color : red";> &|#x1F311; </span>'; AS ''

 

FOR

CAR.COMP.CAR

JAGUAR AS JAGUAR LABEL R0010 OVER

BMW AS BMW LABEL R0020 OVER

RECAP R1000=R0010;

AS Jaguar OVER

RECAP R1010=R0010+R0020;

AS Jaguar and BMW

ON TABLE SET PAGE-NUM NOLEAD

ON TABLE SET ASNAMES ON

ON TABLE NOTOTAL

ON TABLE PCHOLD FORMAT HTML

ON TABLE SET HTMLEMBEDIMG ON

ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *

INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,

$

ENDSTYLE

END

Current Results :