Skip to main content

Formula to divide two integers gives 0

A

Hi all,

I have one field that holds ENROLLMENT (total students enrolled, formatted as an integer number) and another field that holds RACE (total number of students of a given race, also formatted as an integer number). I need a field that calculates % RACE, so I formatted that field as a formula, then used the field selector to select RACE / ENROLLMENT (which airtable writes as {RACE} / ENROLLMENT). However, it gives 0 all the way down the table. All other operations (+, -, *) give accurate values if I replace the division bar with those symbols.

Any idea why trying to do division returns 0s? (None of the values in the ENROLLMENT or RACE fields are 0.)

    4 replies

    J
    Forum|alt.badge.img+18

    Airtable doesn’t give actual percentages, the way that Excel does. You have to do the conversion yourself by multiplying by 100.

    ({RACE} / ENROLLMENT) * 100

    And then format your formula field as a Percentage (using the “Format” menu.

    S
    E
    2 people like this
    • S
      shanemileham
    • E
      Elias_Gomez_Sai
    A
    • Angela_Knotts
    • Author
    • New Participant
    • 2 replies
    • December 17, 2018
    Jeremy_Oglesby wrote:

    Airtable doesn’t give actual percentages, the way that Excel does. You have to do the conversion yourself by multiplying by 100.

    ({RACE} / ENROLLMENT) * 100

    And then format your formula field as a Percentage (using the “Format” menu.


    But it doesn’t give accurate quotients at all. Just zeros. That won’t be solved by multiplying by 100.

    J
    Forum|alt.badge.img+18
    Angela_Knotts wrote:

    But it doesn’t give accurate quotients at all. Just zeros. That won’t be solved by multiplying by 100.


    I’m pretty sure it should, because you likely have your formula field formatted as Integer. If your division results in the actual value of 0.4 (ie, 40%), and you have it formatted to round to the nearest integer, the field will show 0.

    If it just happens to be the case that all of your quotients are 44% or below, then you’ll see all 0’s with your current set up.

    S
    E
    2 people like this
    • S
      shanemileham
    • E
      Elias_Gomez_Sai
    A
    • Angela_Knotts
    • Author
    • New Participant
    • 2 replies
    • December 17, 2018
    Jeremy_Oglesby wrote:

    I’m pretty sure it should, because you likely have your formula field formatted as Integer. If your division results in the actual value of 0.4 (ie, 40%), and you have it formatted to round to the nearest integer, the field will show 0.

    If it just happens to be the case that all of your quotients are 44% or below, then you’ll see all 0’s with your current set up.


    Ohhhhh I get it. Yep, that works. Thanks!

    J
    1 person likes this
    • J
      Jeremy_Oglesby

    Reply


    Most helpful members this week

    Terms & Conditions