enquirerfm Posted March 4, 2011 Share Posted March 4, 2011 I have a field which I have set up as a calculation to pull in data from several fields - it is designated as a text field. One piece of data I want is numeric - contains a percentage. In the original field it is set up as a number which present itself as a one decimal point percentage e.g. you have to key in .125 to arrive at 12.5% as it is reprented in the originating field. Now, if I use GetAsText in my new field I obtain 0.12. If I use GetAsNumber it is also 0.12. How can I obtain 12.5% ? Thx. Link to comment Share on other sites More sharing options...
comment Posted March 4, 2011 Share Posted March 4, 2011 Try = YourValue * 100 & "%" Link to comment Share on other sites More sharing options...
enquirerfm Posted March 4, 2011 Author Share Posted March 4, 2011 Yes, this works great - should have thought to do this. Is there a way I can omit a result when it would otherwise show 0%? Link to comment Share on other sites More sharing options...
comment Posted March 4, 2011 Share Posted March 4, 2011 Case ( YourValue ; YourValue * 100 & "%" ) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4800 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