Setting number precision as text

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

Recommended Posts

I have a number field that I want to display as part of a calculated result in a text field. I want to the number to display as a decimal (ie 50.00). I have tried using SetPrecision( number_field ; 2 ) and Truncate( number_field ; 2 ). I have tried different combinations of GetAsText and GetAsNumber.

Here's one way I tried:

Let ( amount = SetPrecision ( numberField ; 2 ) ;

"Date: " date & "; Amount \$ " & amount )

No Luck. It seems like these ideas would work, but NO. Any help? Thank you.

Quillpro

Share on other sites

If your number field raw data is entered as 50.00 than FileMaker in Version 8 will retain the format.

so, this:

"Date: " & Date & " Amount: " & Numberfield

should do it.

HTH

Lee

Edited by Guest
Share on other sites

Hi

you can try this too:

Let([

i = If ( Int ( number ) = 0 ; 0 ; Int ( number ) ) ;

d = If ( Mod ( number ; Int ( number ) ) = 0 ;".00" ; Left ( Abs ( Mod ( number ; Int ( number ) ) ) & "00" ; 3 ) )

];

"Date: " date & "; Amount \$ " & i & d

)

Share on other sites

Or simply:

Int ( numberField ) & "." & Right ( "00" & numberField * 100 ; 2 )

This is assuming numberField is pre-rounded to 2 decimal places and never negative.

Share on other sites

I want to display "Date: " date & "; Amount \$ " & amount )
.

You may not need a calc at all. Might merge field work for you?

`Date: <> Amount \$: <>`

You can then format the date and the amount as you wish by selecting the merge field, right-click and select number format (change to 2 decimals) or date format to specify your date display.

Share on other sites

• 3 weeks later...
• Newbies

I am having a similar problem to QuillPro. I am manually summarising data using global fields and Get Summary function. The results are placed in one field. This field needs to be a text field as there is text in this field as well. As a result, all numbers are stripped back to form they were input. So "5,005.50" ends up as "5005.5" etc.. Is there any script that will maintain the 2 decimal places and the thousands separator? Merge fields will not work for me as there may be a number of results in each summary.

Share on other sites

For non-negative amounts, pre-rounded to 2 decimal places, with a single thousands separator, you can use:

Case ( Div ( Amt ; 1000 ) ; Div ( Amt ; 1000 ) & "," )

&

Right ( Int ( Amt ) ; 3 )

& "." &

Right ( "00" & Amt * 100 ; 2 )

For more complex options, see here.

Share on other sites

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

Create an account

Register a new account