I have 3 node types: 1st one is projects node type and has a field that keeps amount of money billed. 2nd one is firms node type and keeps information about firms to that processes are billed. 3rd one is payments node types that keeps information about payments made by firms for projects.
one project can have only one firm, one firm can have many projects and many payments, payments can have only one projects. I hope I am clear for all explanations.
what I am trying to do is that I can sum all bills (in projects) results for a single firm and when adding new payments (in payments), debt amount in firm's account goes down.
I tried to do that with computed field but after some point I cannot visualize how I can combine the results from different node types.