I need to compare the values of two column totals. In this example I would like to set the color of the greater value of (total) DEALER_COST and (total) RETAIL_Cost.
TABLE FILE CAR
SUM
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.COMP.CAR
ON TABLE COLUMN-TOTAL AS 'TOTAL'
END
Thanks, DavidThis message has been edited. Last edited by: David M,
WebFOCUS 8.1.05M, 8.2.02M Windows, All Outputs
May 31, 2018, 10:19 AM
Chaudhary
TABLE FILE CAR
SUM
CAR.BODY.DEALER_COST
TOT.CAR.BODY.DEALER_COST NOPRINT
CAR.BODY.RETAIL_COST
TOT.CAR.BODY.RETAIL_COST NOPRINT
BY CAR.COMP.CAR
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET STYLE *
TYPE = DATA ,
COLUMN=N2,
COLOR = 'RED',
WHEN=N3 LT N5,
$
ENDSTYLE
END
Thank you for your response, but I am trying to highlight just the TOTAL amount not the whole column.
WebFOCUS 8.1.05M, 8.2.02M Windows, All Outputs
June 01, 2018, 09:10 AM
MartinY
TABLE FILE CAR
SUM
CAR.BODY.DEALER_COST
TOT.CAR.BODY.DEALER_COST NOPRINT
CAR.BODY.RETAIL_COST
TOT.CAR.BODY.RETAIL_COST NOPRINT
BY CAR.COMP.CAR
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET STYLE *
TYPE = GRANDTOTAL,
COLUMN=N2,
COLOR = 'RED',
WHEN=N3 LT N5,
$
ENDSTYLE
END
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
June 01, 2018, 09:32 AM
David M
Works perfectly, thanks.
WebFOCUS 8.1.05M, 8.2.02M Windows, All Outputs
June 04, 2018, 07:38 AM
Chaudhary
quote:
TABLE FILE CAR SUM CAR.BODY.DEALER_COST TOT.CAR.BODY.DEALER_COST NOPRINT CAR.BODY.RETAIL_COST TOT.CAR.BODY.RETAIL_COST NOPRINT BY CAR.COMP.CAR ON TABLE COLUMN-TOTAL AS 'TOTAL' ON TABLE SET STYLE * TYPE = GRANDTOTAL, COLUMN=N2, COLOR = 'RED', WHEN=N3 LT N5, $ ENDSTYLE END
we can use WHEN condition on total directly
TABLE FILE CAR
SUM
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.COMP.CAR
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
TYPE = GRANDTOTAL,
COLUMN=N3,
COLOR = 'GREEN',
WHEN=N3 GT N2,
$
ENDSTYLE
END