I have some tables one of which is contributors and another is contributions. The contributions primary field is the amount of the contributions. One of the contributions field is the Contributor linked field (linked to contributors). I am attempting to sum the contributions from each contributor but it is not working out. Is there a way to sum the contributions attributed to each contributor?
Summing data over tables
With the architecture you describe, you should be able to use a rollup field in the [Contributors] table that follows the linked record to [Contributions] and sums the contribution amount. You don’t say exactly why it isn’t working — might you have stored the contributed amount in [Contributions] as a single-line text field rather than a number value? If so, create a formula field in [Contributions] named something like {ContributionValue} with the formula VALUE({ContributionAmount}) (or whatever the name of the primary field is) and roll up that field with the aggregation function SUM(values).
With the architecture you describe, you should be able to use a rollup field in the [Contributors] table that follows the linked record to [Contributions] and sums the contribution amount. You don’t say exactly why it isn’t working — might you have stored the contributed amount in [Contributions] as a single-line text field rather than a number value? If so, create a formula field in [Contributions] named something like {ContributionValue} with the formula VALUE({ContributionAmount}) (or whatever the name of the primary field is) and roll up that field with the aggregation function SUM(values).
That sounds like a possible solution. I am real new at this, although a bit of database experience, haven’t gotten to the roll up function. Not even sure how to use it. Well,more studying. But thank you
With the architecture you describe, you should be able to use a rollup field in the [Contributors] table that follows the linked record to [Contributions] and sums the contribution amount. You don’t say exactly why it isn’t working — might you have stored the contributed amount in [Contributions] as a single-line text field rather than a number value? If so, create a formula field in [Contributions] named something like {ContributionValue} with the formula VALUE({ContributionAmount}) (or whatever the name of the primary field is) and roll up that field with the aggregation function SUM(values).
Just as an update, I did study the use of roll up and it worked exactly as expected.
Thanks again for the help
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.