Skip to main content

Hi all. I’am trying to create this logic:

I have 2 type of Contacts: Individual Contacts and a Companys as Contacts.

Company may have some individual contacts as “children”. Linked to same table (!)

And i have Task table, each contact (individual or company) have many Tasks.

In a Task table a have a Price field, that field is alsa calculated as “Sum of Price” in Contact table. Thats working well. Now i want to calculate a sum for a Company (Sum of ‘Sum of Price’ for each parent contact). And i cant do it, i see an error “Sorry, there was a problem saving this field. Can’t save field because it causes a circular reference”. Can you recommend something?


Upd: Incorrect description. I made rollup calculation of ‘Sum of Price of my children contacts’ but i cant summerise Companys ‘Sum of Price’ & ‘Sum of Price of my children contacts’

The field i want to sum ‘Sum of Price from related Tasks’ + ‘Sum of Price from related Tasks to my related children’

Be the first to reply!

Reply