Development is wanting an exact revenue amount for each of the current memberships in the database. Membership Recognition amount was the first thought but this field is not always accurate if there is an adjustment or upgrade/additional gift. Our Campaign and Fund reports do not run on a list (which I have created for each level) and the constituent current giving report, running on those lists, is not showing actual money in the actual current membership. Attempts at using TStats is also proving inaccurate Dollar amounts.
Has anyone ever be able to extract exact revenue by member level by list?
Any help would be appreciated!!