Setting number precision as text

[quillpro]

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

[Lee Smith]

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 September 25, 2006 by Guest

[Raybaudi]

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

)

[comment]

Or simply:

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

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

[LaRetta]

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.

[frankie]

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.

[comment]

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.