Forum Discussion

Winss's avatar
Winss
Qrew Trainee
3 years ago

Quickbase function for getting the quotient

What is the quickbase function for getting value of quotient in division. Eg. 16//3 should give 5. 18//3 gives 6. 21//2 gives 10

------------------------------
Winss Albo
------------------------------
Formulas and functions

2 Replies

Sort By
  • DonLarson's avatar
    DonLarson
    Qrew Commander
    3 years ago
    Winss,

    One way to solve this is to use the Integer  function to capture the whole numbers from the division of the number

    [Numerator]
    [Denominator]

    Int( [Numerator]/[Denominator])

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------
    • Winss's avatar
      Winss
      Qrew Trainee
      3 years ago
      Thanks Don.
      For anyone having the same problem you can find this also using
      ( [Numerator] - Rem(Numerator, Denominator) )/ [Numerator]
      Rem is QuickBase function to return the Reminder of a division operation.

      ------------------------------
      Winss Albo
      ------------------------------