sum a specific column when the child record is in a specific location
I have a table where users can select a parent record in more than one location. For example, a child table, "work order" contains both "Service 1", and "Service 2" links to the "services" table. Each linked service has an associated quantity column in the "work order" table. I have tried using the sum function in the "services" table to sum the total services entered but when I sum the "service 1 quantity" all of the values in that column are added regardless of whether the service was a parent record in the "service 1" link or in the "service 2" link.
Thank you for reaching out! We would be happy to assist here, however this is a bit more of an account specific question that would require us to look into your individual account to get a better understanding of why this could be occurring. With that in mind, we would recommend submitting a support request so that we can log into your account and investigate this further. You can connect with our support team directly by sending an email to email@example.com or by giving us a call at 800-673-3302. Please feel free to reach out at your convenience.