In Excel you can format a number $1,638,000.00 as $1.64 and...

[NYCBabak .]

If you mean 1.64 M you might be able to use COMPACTFORMAT. Take a look at this doc to see if it does what youre asking.

https://webfocusinfocenter.informationbuilders.com/wfappent/TL5s/TL_srv_rel/source/7709_function_compactformat.htm#reference_CD026E1167FE464CBAC422308E95AC05

Keep in mind once you convert the number with this function, the value is an Alpha and you wont be able to use it in calculations anymore.

[JUAN ORTIZ]

In Excel you can format a number $1,638,000.00 as $1.64 and in a note above the chart you would write something like Numbers Expressed In Millions. Can this be done in a Web Focus report What I am currently doing is dividing my report amounts by 1,000,000

We are using WebFOCUS Enterprise Edition 8.2

[Charles Morris 2]

if youre already using a note not attached to the chart/report as actual data, you can continue to do the same and keep doing the divide. otherwise, Babeks comment will work

[JUAN ORTIZ]

Thanks, everyone. COMPACTFORMAT worked, but not as I need it. I decided to keep using the division function, formatting the result using D12.2. In my Example: 1,638,000 / 1,000,000 = 1.64