Added condition in query to select only transactions that involved cash payments to include in revenue calculations.