List of Calculations and Formula parameters and examples.

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › List of Calculations and Formula parameters and examples.

Tagged: 

Viewing 4 reply threads
  • Author
    Posts
  • February 10, 2012 at 12:28 AM #3608

    tmerwick
    Participant

    Does anyone have a list of Calculations and Formula parameters and examples that can be used in the Calculation field type. The current User Manual has nothing!

    February 10, 2012 at 12:33 AM #5096

    Brendan
    Keymaster

    Hi Tmerwick,

    There’s not much to it right now. You just pick a field, pick an operator, enter in a value, use some brackets, pick another field, etc. This lets you build up a formula such as:

    Total = [Price] x [Quantity]

    or with tax:

    Total = [Price] x [Quantity] x 1.0.5

    Where [Price] and [Quantity] are the names of the fields you’d like the calculation to based upon. The x will show up as an asterisk in the formula. But I just put it as an x here for clarity. “Total” is the name of the calculation field itself.

    Hope that helps!

    Thanks!

    Brendan

    February 10, 2012 at 5:19 PM #5098

    tmerwick
    Participant

    Thanks Brendan! Math 101!

    March 24, 2012 at 6:31 PM #5150

    dave
    Participant

    Brendan, it would be very useful to me to be able ti use the result of another calculation field in another calculation. I noticed that calc fields are not available for calculations. Thanks

    March 24, 2012 at 6:33 PM #5151

    dave
    Participant

    Sorry I just saw this answer in another thread. Thanks.

  • Author
    Posts
Viewing 4 reply threads

You must be logged in to reply to this topic.