digits after cooma

  • Resolved dataeurope

    (@dataeurope)


    4 years, 1 month ago

    Hi
    I am trying to create a calculation form and it is all working fine except that the result shows more digits after the comma than required. I only need two. I′m not sure what I′m doing wrong. I′ve tried with PREC but it doesn′t work. Can anyone help?

    This is what I put in which calculates perfectly but I just need two digits after the comma:
    SUM((fieldname18-fieldname17)/fieldname14*100)

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @dataeurope

    The PREC operation requires a second operand with the number of decimal digits. Furthermore, in your equation, the use of SUM operation has no sense. The equation should be edited as follows:

    
PREC((fieldname18-fieldname17)/fieldname14*100, 2)

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘digits after cooma’ is closed to new replies.