Calculation field – format tags

  • lhycweb

    (@lhycweb)


    4 years, 3 months ago

    Hi Roland,
    I have just found the new Calculation Fields, a great addition to PDB. They solve a problem for me, calculating the number of weeks between two dates and then using the result to calculate a charge. I have it working using variables from another radio button field. The snag I have come across is, I really need the result to display as currency ie two digits to the right of the decimal point. I have tried the format tag [?round_2] which obviously rounds a decimal to 2 places, but instead of displaying currency as x.y0, it drops the 0 and displays as x.y Is there a format tag or other way of displaying the result as currency?

    Thanks
    David

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Roland Barker

    (@xnau)

    4 years, 3 months ago

    This is a good idea, I’m putting this into the next release.

    As it is, there’s no way to force it to show the trailing zeroes after the decimal point.

    Thread Starter lhycweb

    (@lhycweb)

    4 years, 2 months ago

    That’s great. That will allow me to automate a form that currently requires counting weeks off a calendar and multiplying by the weekly charge.
    Thanks
    David

    Thread Starter lhycweb

    (@lhycweb)

    4 years, 2 months ago

    Hi Roland,
    The addition of the calculation fields and now the currency format tag have improved my forms significantly.
    Just another suggestion for another future update. I’m using calculation fields on existing records in a multipage form. As the calculation updates on the next button, would it be possible to make a calculation field hidden on one page and visible on the next page? So if a calculation field total is changed by user input, the old value isn’t shown until it has recalculated.

    Thanks
    David

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

The topic ‘Calculation field – format tags’ is closed to new replies.