Skip to main content
Solved

Display a result in fraction form

S

Hello there smart folks! I am building a base for small film productions, and the industry has some odd practices I have to work around. One of those is tracking scenes on scripts in page length in fractions - specifically 8ths.

For my personal tracking I have a column that just holds the size in the total number of 8ths (so instead of showing 1/8 page it is 1, 1 and 3/8 pages is 11) which I can then total into total number of 8ths.

I now need to convert that back into pages in fraction form to display on one of my reports. So say I have 10 scenes over 5 3/8 pages (so my total is 43). How do I create that 5 3/8 to display?

I hope this makes sense!

Best answer by Ron_Daniel

With some work, this could probably be reduced to one field/formula. But for expediency's sake, try this:

Whole Numbers formula:

ROUNDDOWN({Number of 8ths}/8, 0)

Remainders formula:
{Number of 8ths}-({Whole Numbers}*8)
Fractions formula:
IF({Whole Numbers}=0,
CONCATENATE(Remainders &"/8"),
IF(Remainders>0,
CONCATENATE({Whole Numbers} & " " & Remainders &"/8"),
{Whole Numbers}
)
)
View original
    Did this topic help you find an answer to your question?

    8 replies

    R
    • Ron_Daniel
    • Inspiring
    • 104 replies
    • Answer
    • January 16, 2023

    With some work, this could probably be reduced to one field/formula. But for expediency's sake, try this:

    Whole Numbers formula:

    ROUNDDOWN({Number of 8ths}/8, 0)

    Remainders formula:
    {Number of 8ths}-({Whole Numbers}*8)
    Fractions formula:
    IF({Whole Numbers}=0,
    CONCATENATE(Remainders &"/8"),
    IF(Remainders>0,
    CONCATENATE({Whole Numbers} & " " & Remainders &"/8"),
    {Whole Numbers}
    )
    )
    pressGO_design
    S
    S
    3 people like this
    • pressGO_design
      pressGO_design
    • S
      Soly
    • S
      Shannon_Bradley
    S

    THANK YOU! Formulas make my brain hurt and I was just staring at this for a while lol. Unless someone teaches us both how to make this smaller I will use it....hooray for hidden fields 😄 

    S
    R
    kuovonne
    3 people like this
    • S
      Soly
    • R
      Ron_Daniel
    • kuovonne
      kuovonne
    kuovonne
    Forum|alt.badge.img+17
    • kuovonne
    • Brainy
    • 5987 replies
    • January 17, 2023

    Here is another option ...

     

    CONCATENATE(
    ROUNDDOWN({Eigths}/8, 0),
    IF(
    MOD({Eigths}, 😎,
    " " & MOD({Eigths}, 😎 & "/8"
    )
    )

     

     

     

    R
    1 person likes this
    • R
      Ron_Daniel
    S

    What a fantastic community 🙂 Thank you ever so much!!!!

    S
    kuovonne wrote:

    Here is another option ...

     

    CONCATENATE(
    ROUNDDOWN({Eigths}/8, 0),
    IF(
    MOD({Eigths}, 😎,
    " " & MOD({Eigths}, 😎 & "/8"
    )
    )

     

     

     


    I'm trying this one (ya reduced fields!) but keep getting errors for missing opening parenthesis? 

    S

    Circling back to this, wondering if anyone else has a formula suggestion to reduce this to a 2-field setup? Sadly what kuovonne suggested continues to come back with errors for me. Would be nice to reduce my very large table by the 2 extra fields 🙂

    M
    • Mdonahoe
    • New Participant
    • 2 replies
    • February 4, 2025
    Ron_Daniel wrote:

    With some work, this could probably be reduced to one field/formula. But for expediency's sake, try this:

    Whole Numbers formula:

    ROUNDDOWN({Number of 8ths}/8, 0)

    Remainders formula:
    {Number of 8ths}-({Whole Numbers}*8)
    Fractions formula:
    IF({Whole Numbers}=0,
    CONCATENATE(Remainders &"/8"),
    IF(Remainders>0,
    CONCATENATE({Whole Numbers} & " " & Remainders &"/8"),
    {Whole Numbers}
    )
    )

    Hi, I feel very silly asking this. I'm trying out airtable for script breakdowns also and I want to display the page count in fractions but I don't track the number of eighths separately. Is there a way to just input fractions into a column and have them displayed as fractions instead of making a whole formula and a separate column to turn 11 (in a how many eighths column) into 1 3/8.

    S
    Mdonahoe wrote:

    Hi, I feel very silly asking this. I'm trying out airtable for script breakdowns also and I want to display the page count in fractions but I don't track the number of eighths separately. Is there a way to just input fractions into a column and have them displayed as fractions instead of making a whole formula and a separate column to turn 11 (in a how many eighths column) into 1 3/8.


    If you don't need to have anything else use the number, you can just have it as a text box and put the fraction value in to display. However my setup I have the pages being summarized in other places so it won't do the job lol.

    Reply


    Most helpful members this week

    Terms & Conditions