Total Not Adding Up Correctly

[Anonymous]

Quick Break Down:

1. A person can be a Flex Manager, COBRA Manager, or both simultanoeusly for an account.

2. My "Value" column is consolidating people's names so I can get full counts regardless if they're a COBRA/Flex Manager. This was done in query editor using an index on each row and unpivoting columns.

3. Merged column is just combining the Flex and COBRA columns.

The Data:

 

The issue:

The promoter column is giving me a total of 50, however when adding everything manually by hand I get 51. I can't figure out where or why it would be counting incorrectly. Any ideas?

[dedelman_clng]

Is "Promoter" a column or a measure? Often times measures don't behave the way you expect on a visual total because of a nuance in the way it was written.

Hope this helps

David