Michel Pageau Posted November 1, 2021 Posted November 1, 2021 Try this: DEFINE FILE CAR CAR_COUNT/D12 = 1; END TABLE FILE CAR SUM CAR_COUNT AS '# of Cars' OVER DEALER_COST/D12 AS 'Dealer Cost' OVER RETAIL_COST AS 'Retail Cost' COMPUTE PCT_COST/D12.1% = (DEALER_COST/RETAIL_COST) * 100; AS '' OVER CNT.COUNTRY AS 'Country' ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * TYPE = REPORT, COLUMN = P1, SQUEEZE = 0.68,$ TYPE = REPORT, COLUMN = P2, SQUEEZE = 0.6 ,$ TYPE = REPORT, COLUMN = P3, SQUEEZE = 0.6 ,$ TYPE = REPORT, COLUMN = P4, SQUEEZE = 0.6 ,$ TYPE = REPORT, COLUMN = P5, SQUEEZE = 0.73,$ INCLUDE = endeflt, $ ENDSTYLE END
Michele Brooks 2 Posted November 1, 2021 Author Posted November 1, 2021 Need to know how to line up and right justify the counts and percentages columns. [DEFINE FILE CAR CAR_COUNT/D12 = 1; END TABLE FILE CAR SUM CAR_COUNT AS # of Cars OVER DEALER_COST/D12 AS Dealer Cost OVER RETAIL_COST AS Retail Cost COMPUTE PCT_COST/D12.1% = (DEALER_COST/RETAIL_COST) * 100; AS OVER CNT.COUNTRY AS Country ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ ENDSTYLE END/]
Michele Brooks 2 Posted November 2, 2021 Author Posted November 2, 2021 Thank you so much Michael. This is exactly what I needed. I tried WIDTH and that did not work. Thanks again.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now