Skip to Content
avatar image
Former Member

Value getting roung off while using to text .

Dear Experts ,

I am applying below formula in Display String , But my value getting Round off .

for Ex : totext (41.665,'###,####,###.000') . I am getting output value as 41.670 , but i want to display 41.665 . Please suggest .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 20, 2016 at 06:58 AM

    Hi Sri,

    u can try below hope this help

    totext (41.665,'###,####,###.000',3)

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2016 at 09:28 AM

    Use this instead

    totext(41.665,3, ",")

    Ian

    Add comment
    10|10000 characters needed characters exceeded