Michel Pageau Posted November 1, 2021 Share 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 Link to comment Share on other sites More sharing options...
Michele Brooks 2 Posted November 1, 2021 Author Share 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/] Link to comment Share on other sites More sharing options...
Michele Brooks 2 Posted November 2, 2021 Author Share 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. Link to comment Share on other sites More sharing options...
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