Decimal places

  • Resolved trde

    (@trde)


    7 years ago

    How to reduce decimal places? It’s really annoying that every calculation show about 12 useles decimal places. I need to have only $ amount like: 20,99$ or 38,24$

    My RESULT field looks like this:

    (1629.75 + fieldname10 + fieldname9 + fieldname8 +
    fieldname7 + fieldname6 + fieldname2) * fieldname13

    • This topic was modified 7 years ago by trde.
    • This topic was modified 7 years ago by trde.
Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @trde,

    You simply should use the “PREC” operation:

    PREC(X,Y) returns the number X rounded to Y decimal places.

    For example:

    PREC(3.2651,3) = 3.265
    PREC(3.2651,2) = 3.27

    In your equation, its use would be:

    PREC((1629.75 + fieldname10 + fieldname9 + fieldname8 +
    fieldname7 + fieldname6 + fieldname2) * fieldname13,2)

    and that’s all.
    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Decimal places’ is closed to new replies.

Tags