Forum Discussion

TheSAY's avatar
TheSAY
Frequent Visitor
7 years ago

Calculated Filter - Wrong Total

Hello,

 

I seem to be having an issue when trying to pull the amount of participants for a report.

 

Here is the link to a ZIP file of the report and source files: https://1drv.ms/f/s!Ar-qf5t6I8TOo0ME1gKSvyjbC_JU

 

There are two reports I run with the membership software we use, and I've been able to get them combined to show the correct amounts per YTD based on the selected month(s) in the slicer.

 

However, if you look at the 2019 Participants column currently there, the "Membership" category is only listing the total as 390. This should be 402 when you add all the numbers up.

 

Are my formulas correct? Why would it not be adding everything up correctly?

Need Help

2 Replies

  • calerof's avatar
    calerof
    Icon for Impactful Individual rankImpactful Individual
    7 years ago

    Hi TheSAY ,

    Your measure is correct in each subtotal as well as in the total count.  

    The reason is because you have the same member in different categories, those are:

     

    Regards,

    Fernando

     

    • TheSAY's avatar
      TheSAY
      Frequent Visitor
      7 years ago

      Hi Fernando calerof 

       

      Thank you for getting back to me.

       

      Do you know how I would go about getting duplicates included?  Would I need to base it off the member name and the adjustment type perhaps?

       

      For example, with one of the names listed below, Keyla Alberto, they're being duplicated due to "7th Grade Initiative" and "Achievers".  Since the combination of columns will be "Alberto, Keyla-N/A - Unit Level Adjustment" for both, would I need to do it as "Alberto, Keyla-7th Grade Initiative" and "Alberto, Keyla-Achievers"?