Test Menu

  • Commentary
  • Deals
  • Coupons

Dec 14, 2011

Crystal Reports - Text or Text Number With Three Decimal Places


This is a Crystal Report formula field.  The requirement is to display the string 'No Data' when the value is null and if it isn't null show the number with three decimal places.To display 'No Data' both parts of the if must be converted to text.

If NumericText ({SupplierStatistic.pHMin}) Then 
    ToText(ToNumber({SupplierStatistic.pHMin}),3)
Else
    'No Data'

No comments:

Post a Comment