It can't be one with a calculation formula. It requires additional design details--a relationship that only matches to active records, performing a find for all active records or a portal filter that omits all but active records are all possible ways to get such a "selective" total.
And if you have FileMaker 12, there's a way to get this total with the Execute SQL function.
OK, not easy at all. I have FM 12, could you explain how to do it with the Execute SQL function as it is not something I am familiar with,
Many thanks :)