I am new to Podio and am struggling with the calculations. I want to achieve something but I don't even know if it's possible.
I have 2 apps called investors and deals. In the investor app I have a field that says how much money in total that investor wants to invest. Now I want to calculate the money (per investor) that is still available for investing in deals by subtracting the amount that the investor already has invested in deals from the total amount they want to invest to get the amount available for investing for that specific investor. So the calculation should look like this: Total amount to invest - amount invested in deals = amount available for investing.
In the deals app I have created 3 relationship fields (because each deal can have a maximum of 3 different investors) called investor 1, investor 2 and investor 3 to select the specific investors for that deal and 3 currency fields called amount invested by investor 1, 2 and 3. The goal is to use these amounts in my calculation.
I hope it's possible to achieve this. Thanks in advance for your help!
Please sign in to leave a comment.