The household revenue amount smart field was added to CRM in a recent version, and only has a date filter. When running this smart field for latest revenue amount it makes sense to leave the start date blank which effectively scans all revenue in the database to find the desired piece of revenue and it's application amount. This calculation will complete in smaller databases or when using a limited date range, but runs for an excessive amount of time when leaving the filters off on larger databases
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.