Contact us
Jump to content

Is there a command to round to the nearest whole number in WebFOCUS?

Denise Phillips

By Denise Phillips
in WebFOCUS

 Share

Recommended Posts

Martin Yergeau Proficient

Martin Yergeau

Posted
Posted

You can simply change the field format as per below sample code

DEFINE 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

SAMPLE.jpg.d0ca82710097a021a7053560b734c190.jpg

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...
© 2024 Cloud Software Group, Inc. All rights reserved.