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?
Many thanks,
Tom
Best answer by Milan_Automable
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.
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
+3Hi @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.
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
Hi Milan, this was so clear and helpful, and immediately resolved my issue - thank you so much!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
