donjuan1498 Posted April 16, 2018 Share Posted April 16, 2018 I have a field that contains a "percentage". I get data from several outside sources to populate this field. The rub is I need to format this field to read correctly as a percentage example 55% or 100%. The data come from outside sources as follow 100, 100%, 100.00 or sometime 1. Another example 55, 55%, 55.00, & .55.I would need this to all be one format with a condition, but I am having a hard time figuring out how to do this. I am sure it is easy but I am stumped. Link to comment Share on other sites More sharing options...
Steve Martino Posted April 16, 2018 Share Posted April 16, 2018 (edited) It's not as easy as you may think. For example, what happens when you get .55. Do you know they meant 55% or is it .55%? Also, how do you know 1 means 100% and not 1%? If it's always going to be whole numbers, it makes it easier. What's the 'outside sources' ? Can the formatting get fixed there first? Can the formatting be fixed before import? Edited April 16, 2018 by Steve Martino Link to comment Share on other sites More sharing options...
Aussie John Posted April 18, 2018 Share Posted April 18, 2018 For my purposes I use auto entry calculation which says case( x=>1,x/100,x) and format as percent. With caveat this fails if there are ever anticipated results of less than 1 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2198 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now