Hi Scott,
Welcome to EG and the forum! What you're describing is 100% doable within EG. I would suggest:
1. A Summary Statistics task wizard to calculate the total donations and total calls values. Have the wizard create an output data set.
2. A Query task, on the output data set from step 1, to create a computed column with the average donation per call. This also gives you a chance to select only the columns you want to report on since there will be others in the table from step 1.
3. A List Data task on the data set generated in step 2. This will allow you to format column values as needed, get the order of the columns the way you want etc.
These steps could be combined somewhat by using some of the advanced features of the Query task (aka Query Builder, aka Filter and Query) like summarized columns, computed columns, and the option to create a report directly from a query. The Query task writes PROC SQL code behind the scenes, so 95% of what you can do within ANSI standard SQL can be done point-and-click in the Query task. You can also write your own PROC SQL code if you feel more comfortable doing that.
In Enterprise Guide, be aware that tasks such as Summary Statistics or the Query Builder are often used to prep the data before using a reporting or analysis task. So, what you want many not be easily done using a single task, but might be a snap using two or more tasks one after another.
Richard
... View more