Try count distinct anyway and data blending can cause incorrect totaling.
ah count distinct! Kelly you are my hero. The donation ID is used on the account, contact, opportunity field history, opportunity history, and task objects. I assume Tableau was counting every instance of the donation ID across all objects.
Thank you so much!
No problem I'm glad it helped