Results 1 to 4 of 4
  1. #1
    Join Date
    May 2012
    Posts
    2

    Unanswered: Allow 3 decimals for a specific code

    I work for a government contractor and GSA recently increased the mileage reimbursement rate from $0.51/mile to $0.555/mile. I need to have our expense reports show the 3 digit value for this expense type and leave the rest as normal 2 digit.

    How do I write the if-then-else statement to do that?

    Thank you in advance for the assistance.

    CK

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    doubt you need to
    I'd expect you change the display format to 3 decimal spaces, UNLESS you have sepcified only 2dp for storage.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2012
    Posts
    2
    the database stores the values correctly, however the report formats the field as 2 decimal places, just have this one expense type that needs to be displayed as 3 decimal places. the reports rounds the field to $0.56, which is incorrect.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    no, its doing what its told to
    the problem is your design not Crystal Reports. However its years since I've dabbled with Crystal reports. As sdaid before I'd expect you to have to change the format mask / format property of the relveant control / object. set it to 3DP. you may need to chaneg the format type to be say a number rather than currency
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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