Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Numeric Value Field in Merge to Layout


This topic is 6028 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

On Filemaker Pro 9 I have set up a field with numeric values as a currency with two decimal places (e.g. £100.00) however, when this information is merged over to a Layout that i have set up, the merge field only appears as 100 without the £ or the decimal places.

The two decimal places only appear if they are not zeroes.

Please can anyone advise how i can enable this field to merge as it is shown originally?

Thanks

Posted

FileMaker only stores the necessary information. I.e. it will not store the $ etc., nor the leading or trailing 0 that are not whole numbers. i.e. .10, it will only show the.1, or .00 it will not store or show either 0.

You can format the <> by using the number format in Layout.

HTH

Lee

This topic is 6028 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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