Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 01, 2020 05:33 AM
Hi - I have a table with a list of cash flows, dates. These are linked to another table which contains individual deals. I want to calculate, for each deal, the IRR - in Excel this is using the IRR function which takes a list of dates and a list of cash flows and returns a single IRR number.
Can this be done in Airtable? Rollups seem to only allow calculations involving one linked field only - whereas I need two: both date and cashflow. Also, there doesn’t seem to be an IRR function. The calculation is relatively straight forward, can I code my own function to support this?
Secondary question - right now I have to manually for each date/cash flow record link it to a given deal. Is there a way to link all cash flows where dealID equals x?
Aug 01, 2022 09:16 AM
I posted a short script awhile back for it
Aug 01, 2022 09:18 AM
do you have experience with their extension? any thoughts?
Aug 01, 2022 09:29 AM
@Hannah_Wiginton knows all about it! :slightly_smiling_face:
Aug 01, 2022 10:17 AM
Hey @JonahM
The IRR automation is in our On2Air Actions app. You can start a free trial to test it out.
We can also do a demo and free setup for you if you prefer that route.
Thank you @ScottWorld !
Aug 01, 2022 11:56 AM
thanks @Hannah_Wiginton @ScottWorld @ATG ! will take a look at the extension as well as the script
thanks!
Oct 17, 2023 12:52 PM
This helped me a lot!
Thanks, I thought you should've had some recognition