Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Calculating a ratio

Topic Labels: Data Formulas
Solved
Jump to Solution
107 3
cancel
Showing results for 
Search instead for 
Did you mean: 
hsat
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there,

I'm looking for a formula to automatically calculate the Venue and Producer split of the Budget and Budget Committed as per the "Deal." However, at present, the "Deal" field is a text entry, and I wondered what the best way to achieve this is?

Deal.PNG

 

Many thanks,

Tom

1 Solution

Accepted Solutions
Milan_Automable
6 - Interface Innovator
6 - Interface Innovator

Hi @hsat ,

I'll use a simplified example, with "Deal" string, and budget. I'll use the first part of the Deal as a percent, to compute the Producer Share.

Milan_Automable_0-1740494383379.png

The formula I used here:

(VALUE(LEFT(Deal, FIND("/", Deal) - 1)) / 100) * Budget

If you use RIGHT instead of LEFT, you can use the second part.

This assumes that this string is always in the same format ({Number}/{Number}). It might also make sense to specify the "Producer Percent" as a number field, and then you can use a formula to compute the Deai to display.

If you can adapt your data structure, this version would be less prone to errors.

I'd love to explore more use-cases of Airtable and automation specific to your business, if you're interested feel free to book a free call at any time that works for you 🙂

-- Best, Milan - Automable.AI

See Solution in Thread

3 Replies 3
Milan_Automable
6 - Interface Innovator
6 - Interface Innovator

Hi @hsat ,

I'll use a simplified example, with "Deal" string, and budget. I'll use the first part of the Deal as a percent, to compute the Producer Share.

Milan_Automable_0-1740494383379.png

The formula I used here:

(VALUE(LEFT(Deal, FIND("/", Deal) - 1)) / 100) * Budget

If you use RIGHT instead of LEFT, you can use the second part.

This assumes that this string is always in the same format ({Number}/{Number}). It might also make sense to specify the "Producer Percent" as a number field, and then you can use a formula to compute the Deai to display.

If you can adapt your data structure, this version would be less prone to errors.

I'd love to explore more use-cases of Airtable and automation specific to your business, if you're interested feel free to book a free call at any time that works for you 🙂

-- Best, Milan - Automable.AI

hsat
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Milan, this was so clear and helpful, and immediately resolved my issue - thank you so much!

Milan_Automable
6 - Interface Innovator
6 - Interface Innovator

Happy to help 🙂

— Best, Milan - Automable.AI Free Airtable consultation