Robert Vitali Posted May 28, 2021 Share Posted May 28, 2021 When using PCT.CNT, how can I get a % sign to display. Ive tried everything I can think of and researched like SET PCTFORMAT = {OLD|PERCENT}. I think Ive tried this before, with no luck. Perhaps it just is not possible yet. Thanks Robert Link to comment Share on other sites More sharing options...
David Beagan Posted May 28, 2021 Share Posted May 28, 2021 On WebFOCUS 8.2.06 TABLE FILE GGSALES SUM UNITS PCT.CNT.UNITS BY REGION END I get a percent sign: Link to comment Share on other sites More sharing options...
Martin Yergeau Posted May 28, 2021 Share Posted May 28, 2021 May depend of version used because on 8.2.04M I have to use the following to get the percent sign displayed TABLE FILE GGSALES SUM UNITS COMPUTE PCTCNT/P6.2% = PCT.CNT.UNITS; AS 'Units,Pct Cnt' BY REGION END Link to comment Share on other sites More sharing options...
David Beagan Posted May 28, 2021 Share Posted May 28, 2021 Does this work for you TABLE FILE GGSALES SUM UNITS PCT.CNT.UNITS/P6.2% BY REGION END Link to comment Share on other sites More sharing options...
Robert Vitali Posted May 28, 2021 Author Share Posted May 28, 2021 Thanks for the reply. No, just adding in P6.2% does not work. Link to comment Share on other sites More sharing options...
Martin Yergeau Posted May 28, 2021 Share Posted May 28, 2021 david.beagan: Does this work for you I have tried also and it doesnt work. Only with the COMPUTEd field Link to comment Share on other sites More sharing options...
Robert Vitali Posted May 28, 2021 Author Share Posted May 28, 2021 I found a work-around for my problem PCT.CNT.[field] WITHIN [group] NOPRINT COMPUTE MY_PERCENT/D12.2%=PCT.CNT.[field]; Link to comment Share on other sites More sharing options...
Martin Yergeau Posted May 31, 2021 Share Posted May 31, 2021 The first PCT.CNT row has no meaning to be there according to me. Only the COMPUTE line is probably solving your issue. 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