Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    6

    Unanswered: CR 9help with format

    what Datatype In FormatNum (, , DataType) should be?:

    so that number is diplayed as:
    3 3.5 4.66 4,567.78 4,567 45 677 etc?.

  2. #2
    Join Date
    Jan 2005
    Location
    Avon Lake, OH
    Posts
    112
    Try this in the 'Display String' formula for the field. The formula uses compares the number against the integer part of the value to figure out whether to include the decimal point and 2 decimal places.

    It works in Crystal 10, but I can't remember if you have 'Display String' formulas in Crystal 9:


    If Int(CurrentFieldValue) = CurrentFieldValue then
    ToText (CurrentFieldValue, 0)
    Else
    ToText (CurrentFieldValue, 2)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •