Add one more decimal

  • Resolved Swissprice

    (@swissprice)


    8 years, 6 months ago

    Hello,

    This plugin is great!

    I would like that, when the calculated field is XXX.1 or XXX.5 (for example), another 0 is added so it looks like XXX.10 or XXX.50 (for example).

    How can I do that? ??

Viewing 4 replies - 1 through 4 (of 4 total)

  • Hi,

    You could try this, the calculated field has a setting called “Symbol to display at the end of calculated field”, just type a 0 in it and it’ll display 0 at the end of the calculated value.

    thanks.

    Thread Starter Swissprice

    (@swissprice)

    Hello,

    Thank you for your reply. ??

    I thought about that but the problem is that not all the results on the calculated field will contain a decimal. Then, for 123$, it’d show 1230$ instead and it’ll be wrong.

    Plugin Author codepeople

    (@codepeople)

    Hi,

    The solution is really simple. Use the “PREC” operation.

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

    For example, if your equation is: fieldname1+fieldname2, modify it as follows:

    PREC(fieldname1+fieldname2, 2)

    Best regards.

    Thread Starter Swissprice

    (@swissprice)

    Hello,

    That worked PERFECTLY!

    Thank you very much for your support!

    Kind regards,
    Samuel

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Add one more decimal’ is closed to new replies.