Denise Phillips Posted September 14, 2022 Share Posted September 14, 2022 Is there a command to round to the nearest whole number in WebFOCUS? Link to comment Share on other sites More sharing options...
Martin Yergeau Posted September 14, 2022 Share Posted September 14, 2022 You can simply change the field format as per below sample codeDEFINE FILE SALESDEF_PRICE /D5M = RETAIL_PRICE;ENDTABLE FILE SALESSUM RETAIL_PRICE AS 'Org Fmt' RETAIL_PRICE/D5M AS 'Dynamic,Whole Nbrr' DEF_PRICE AS 'Defined,Whole Nbr' COMPUTE N_RET /D5M = RETAIL_PRICE; AS 'Computed,Whole Nbr'BY CITYEND Link to comment Share on other sites More sharing options...
Denise Phillips Posted September 14, 2022 Author Share Posted September 14, 2022 Thank you! 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