Leaving only 2 decimal places

Tap Forms Database Pro for Mac, iPhone, iPad and Apple Watch › Forums › Using Tap Forms 5 › Leaving only 2 decimal places

Viewing 3 reply threads
  • Author
    Posts
  • August 25, 2019 at 8:00 AM #36491

    john cesta
    Participant

    I have this in my calculation field

    [Annual]*27/100

    My result is like

    34.337744820

    How to leave only 2 decimal places

    I’ve also tried just .27 for percent and set 2 decimal places in the properties.

    August 25, 2019 at 5:40 PM #36496

    Sam Moffatt
    Participant

    Make sure the output of the calculation is set to number not text. The number formatting options only apply to number outputs. I just did a quick test to do 22/7 in a calculation field and the decimal places setting seemed to work.

    August 25, 2019 at 8:05 PM #36500

    Brendan
    Keymaster

    You also have to make sure you set the Number Format to Decimal, otherwise the Decimal Places property will be ignored.

    August 26, 2019 at 6:27 AM #36511

    john cesta
    Participant

    Number format was set to no style, thanks both.

  • Author
    Posts
Viewing 3 reply threads

You must be logged in to reply to this topic.