Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

GetAsText - percent

enquirerfm
in Calculation Engine (Define Fields)

Featured Replies

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.

Try =

YourValue * 100 & "%"

  • Author

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%?

Case ( YourValue ; YourValue * 100 & "%" )

Create an account or sign in to comment

https://fmforums.com/topic/76951-getastext-percent/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.