Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


JUAN ORTIZ

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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
×
  • Create New...