Rules have some limitations around what data they can access. Sometimes in order to recreate a specific formula, it requires access to raw values rather than just the statistics available in the table.