Skip to Content
avatar image
Former Member

Rounding Off Formula In Crystal Report

Dear Experts,

Need a formula in crystal reports for rounding of numbers

Example

Multiplying two number fields x and y and if result is

1.50 upto1.99 = 1

2.50 upto 2.99 =2

Need help in achieving the above task.

Regards,

Karthik B

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 07, 2016 at 03:17 AM

    Hi Karthik,

    For this purpose you can use the fuction floor({result of your multiplying}) that will round down your value.

    Kind Regards,

    Diego Lother

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Diego Lother,

      Thank you for the help. The given formula resolved the issue.

      Regards,

      Karthik B

  • Nov 07, 2016 at 05:01 AM

    Hi

    Please check bellow link then you may get some idea

    http://www.tek-tips.com/viewthread.cfm?qid=474120

    ___Ramudu

    Add comment
    10|10000 characters needed characters exceeded