Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Display a result in fraction form

Solved
Jump to Solution
129 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

2 Solutions

Accepted Solutions

With some work, this could probably be reduced to one field/formula. But for expediency's sake, try this:
Screen Shot 2023-01-16 at 2.23.26 PM.png

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}
)
)

See Solution in Thread

Here is another option ...

 

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

 

 

kuovonne_0-1673926660373.png

 

See Solution in Thread

4 Replies 4

With some work, this could probably be reduced to one field/formula. But for expediency's sake, try this:
Screen Shot 2023-01-16 at 2.23.26 PM.png

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}
)
)

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 😄 

Here is another option ...

 

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

 

 

kuovonne_0-1673926660373.png

 

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