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

    Round Down Value

    meenamani

      Hi

      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

      event.value=Math.floor(rd,1000);

      Round down pdf.jpg

      If any one can help me I appreciate.

      thanks in advance

      Meena