dollar amounts with two decimal places for consistency

  • Resolved arnab28

    (@arnab28)


    3 years, 12 months ago

    Hello Sir,

    How can I make dollar amounts with two decimal places for consistency for every calculation filed. I notice some of the filed its show two decimal number and some of the filed do not show two decimal number. also, use the decimals separator symbol. Please see the below image URL:https://ibb.co/K556StN.

    Is this another way I am using all calculations filed to show two decimal numbers?

Viewing 15 replies - 1 through 15 (of 17 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @arnab28

    Please, use the PREC operation as the outermost operation in the equations.

    PREC(X, Y) rounds the number X to Y decimals.

    For example, if you have implemented the equation fieldname1*fieldname2 and you want the result with two decimals, you should edit it as follows:

    
PREC(fieldnam1*fieldname2, 2)

    Best regards.

    Thread Starter arnab28

    (@arnab28)

    I am already tried to use this, but its not working some filed

    Plugin Author codepeople

    (@codepeople)

    Hello @arnab28

    Please, send me the link to the form and indicate the values I should enter and the field where the PREC operation is not working.

    Best regards.

    Thread Starter arnab28

    (@arnab28)

    I faced one more issue if the value is 4,428.27 the two digit decimal is okay, if I get the result value 147.4 like this then the decimal 2nd value do’s not show because this value is 0.is it possible dollar amounts with two decimal places for consistency?

    Plugin Author codepeople

    (@codepeople)

    Hello @arnab28

    One more time, please, send me the link to the form and indicate the values I should enter and the name of the field whose equation is incorrect.

    Best regards.

    Thread Starter arnab28

    (@arnab28)

    Hello,

    Please see the below link https://bsbtest.assiduusinc.com/duodenoscope-v4
    Please notice the value- (Purchase price per video tower) field.
    and also notice the value (Video tower cost per use) field.

    Note- make sure you will input value in (Total annual ERCP procedure volume) field – value is 5.65

    Thread Starter arnab28

    (@arnab28)

    if I get the result value 147.4 like this then the decimal 2nd value do’s not show because this value is 0.is it possible dollar amounts with two decimal places for consistency?

    Is this any update from your side?

    Plugin Author codepeople

    (@codepeople)

    Hello,

    The equation in the fieldname136 is fieldname132*fieldname133, it does not use the PREC operation.

    I’m checking the issue with the two decimal places if the additional digits are zero.

    Best regards.

    Thread Starter arnab28

    (@arnab28)

    Please check the fieldname133,fieldname138 and fieldname119. I am getting issues with two decimal places for this field.

    Thread Starter arnab28

    (@arnab28)

    Do you have any solution for this?

    Plugin Author codepeople

    (@codepeople)

    Hello @arnab28

    Please, install the plugin’s update published right now.

    Best regards.

    Thread Starter arnab28

    (@arnab28)

    Do I need to download again or i check all plugin section there is no auto-update option is enabled. Can you help me how can i update?

    Plugin Author codepeople

    (@codepeople)

    Hello @arnab28

    Hi! We’d like to help but we can’t reply about that in this forum. We are not allowed to support any customers in these forums.

    For pro or commercial product support please contact us directly on our site.

    Commercial products are not supported in these forums. We will happily answer this and any other questions you can have on our own site.

    Thank you.

    Thread Starter arnab28

    (@arnab28)

    Hi,

    I’m checking the issue with the two decimal places if the additional digits are zero.
    do you have any solutions for this?

    Plugin Author codepeople

    (@codepeople)

    Hello @arnab28

    I’ve tested your form and it is working fine.

    Best regards.

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘dollar amounts with two decimal places for consistency’ is closed to new replies.