How to Calculate Percentages

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › How to Calculate Percentages

Viewing 3 reply threads
  • Author
    Posts
  • August 6, 2013 at 5:25 PM #6372

    jack
    Participant

    HI
    How DO I Calculate Percentages like cost $10 x 15 Percent = $1.50

    August 7, 2013 at 12:38 PM #6374

    Brendan
    Keymaster

    Hi Jack,

    Just do [Cost] x 1.15 for your formula.

    Thanks!

    Brendan

    August 7, 2013 at 3:55 PM #6376

    DrJJWMac
    Participant

    If you are using a field PercentTip to store the percentage, then you want your formula to say something like this below. Note the placement of parentheses.

    ([Cost] x ([100 + PercentTip]))/100

    August 8, 2013 at 2:16 PM #6388

    Brendan
    Keymaster

    That’s right, because when you use the Percentage Number Formatter, it expects a decimal value between 0 and 1. So 0.5 would display as 50%.

  • Author
    Posts
Viewing 3 reply threads

You must be logged in to reply to this topic.