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-qf5t6I8T...
Need Help
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"?