• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

How do I format a number in a Crystal formula field

How do I format a number in a Crystal formula field?  The formula I have entered in the field is:
formula = {PurchaseOrderLines.UPMLWIDTH} &  "''W x " & {PurchaseOrderLines.UPMLLENGTH} & "'L"

I want to format the field purchaseorderlines.upmlwidth and purchaseorderline.upmllength to show 3 decimals places - (example:  2.253).  Currently, only 2 decimal places are showing and it is rounding up/down.  I am not able to format this field like a normal numeric field in Crystal.  On numeric fields, I normally choose format field and choose the number tab and make my selection.  In this case, the number tab does not show.  

0
aprnka
Asked:
aprnka
1 Solution
 
LinInDenverCommented:
totext(numberfield,3)

this converts the number to text, and out to 3 decimal places
0
 
mlmccCommented:
Looks good.  If the numbers can be larger than 1000 then you may want to also specify the thousand separator.

No thousand separator
totext(numberfield,3,'')

mlmcc
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now