Reconcile the organization by the ID under the Admin/User and Security/Org Units.

You have posted this to Adobe Campaign Standard, and I believe you are using Adobe Campaign Classic which is a different forum.

As an FYI, our organization has implemented Celigo to interface between ACS and Salesforce.  We use a combination of Salesforce SOQL queries (Delta's and Extracts) and ACS (Via S3-SFTP and API).  There is a connector for Salesforce but not for ACS so we use the Http/Ftp methods. John

Try this logic instead. 

I don't see your primary = yes in the query logic.  I had that turned on which sums up in 1 delivery.  I do have recurring deliveries but they are removed and only shows the parent or primary delivery.  When you use Primary = Yes it will not show you single deliveries so I added a Label clause.  

Under properties, is the resource and targeting dimension Deliveries (Delivery)? Add @label in additional data.  Then run the query with the next step paused.  Click on the #record count, click open transition, then data.  You should see this:  

The easy fix is to in you query select Primary = Yes.  That gives you an overall total for that delivery.  If you want a monthly total, you will need to change your recurring deliveries to aggregation period to a Month.  Your example indicates it is set to Day.  If you do the later then you can sele...

The easiest way I found was to query my email address, because I want the email and then add additional data to the query.  The additional should be a key of value of what you want to retrieve.  Then in an enrichment activity bring the data together for the email.

Maybe this will work: Administration/Development/Diagnosis/Data schemas Search for Profile

One way would be to: In a query step you can set up an additional field that would identify the winning To, then reconcile to the profile using the additional field, then send the email.