Focal Point
[CLOSED] Round number

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7297014426

September 24, 2012, 10:40 AM
Candice1284
[CLOSED] Round number
How do I round a number to show in millions? For example, I have a number that is 1,700,000 and I want it to be display on the report as 1.7.

This message has been edited. Last edited by: Kerry,
September 24, 2012, 11:34 AM
Crymsyn
Should be able to make a define like the following:

NEW_NUMBER/D9.1=OLD_NUMBER/1000000;



WF: 8201, OS: Windows, Output: HTML, PDF, Excel
September 24, 2012, 02:04 PM
Doug
This is succinct.