Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Custom Percent Format - No Percent Symbol
Migrateduser
Hi All,
I am using version 3.7.2 and I need a custom percent format (no percent symbol). I have noticed that when I use a custom format, it seems that adding the % to the custom format affects the way the decimal is handled.
For example if I use ##0.0% 1234.56 becomes 123456.0%, which is what I want, minus the % sign.
Using ##0.0 simply produces 1234.6
What I am looking for is a format string that produces 123456.0, and also considers negative numbers which would produce -123456.0 for -1234.56.
I have the 3rd edition field guide and have searched Google but can't find this information in either place. Does anyone know how to accomplish the formatting I am looking for or perhaps a resources that explains how this is done?
Best Regards
David
Find more posts tagged with
Comments
There are no comments yet