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.

Copying data that has been formated

Featured Replies

I have a field that is a text calculation. What it does is takes several other field's info, and puts it all together here.

The problem is, two of my other fields are numbers, that have been formatted as currency, so they show the decimal places and a $ sign. But my calculation in the main field only copies the raw data. I want it to copy the $ and the decimal places.

  • Newbies

There may be a better way, but I'd structure the calculation to format the number as it calculates:

ie: Text + " $" + Round(Amount;2)

where "Text" is your other text fields and "Amount" is your currency field.

  • Newbies

Sorry, I should add that to always force 2 decimal places you need to either use a hidden calculation field that corrects the "Amount" as a properly formatted text string or use the following calculation in your field calculation:

Text & " $" & Round(Amount;2) & Case(Position(Round(Amount;2);".";1;1) = 0;".00"; Position(Round(Amount;2);".";1;1) = Length(Round(Amount;2))-1;"0";"")

Note I foolishly used "+" in my previous post when it should have been "&"..... :-(

Create an account or sign in to comment

Important Information

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

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.