2 Replies Latest reply on Feb 17, 2017 12:14 AM by meenamani

    Round Down Value



      I've Excel formula that Round the value of Perticular Cell. I want to implement this formula for the PDF file.


      here is the excel formula, =FLOOR(P100,1000)

      round Down.jpg


      As you can see it Round Down the value nearest 1000.


      I've try this script to do it but it only nearest value please see attached image

      var rd=this.getField("RD").value


      Round down pdf.jpg

      If any one can help me I appreciate.

      thanks in advance