How do I...?

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.

1 vote
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Nathan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • AdminTrackVia (Community Manager, TrackVia) commented  ·   ·  Flag as inappropriate

    Hello Nathan,

    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 support@trackvia.com or by giving us a call at 800-673-3302. Please feel free to reach out at your convenience.

    Regards,

    Witte

Feedback and Knowledge Base