I have an interesting scenario with hopefully a good solution available. I'd like your help, please!
I have several tables and rows where in a DDP that I'm using to put data into word. I have no problems repeating the table and rows inside the table where necessary.
The wrinkle came when I was asked for a summary of an amount field. I wrote a custom SOQL query using the SUM function and tested in dev console--it works great. However, when I try to use it in Drawloop--I can't figure out how-to make Drawloop treat it like a row within my table.
Is there a special way I need to write the query perhaps? I'm seeking the expertise of the community!