Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Unanswered

Fetchxml: Get sum of all distinct field values with different records

Posted on by 40

Hi,

I have this fetchxml:

  
    
    
      
    
    
      
        
        
          
        
      
    
  

I have this scenario:

Customer Journey Custom Channel 1 (3 records with Contacts):

  • Contact 1
  • Contact 2
  • Contact 3

Customer Journey Custom Channel 2 (2 records with Contacts):

  • Contact 2
  • Contact 4

When I run the fetchxml, it will display 4 since Contact 2 is on both Customer Journey Custom Channel. I want to display 5 instead.

Thank you in advance.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans