This situation usually occurs because of dataset size differences.
Common reasons include:
- Small dataset during development: Since the dataset is small, non-delegable formulas may still return correct results.
- Large dataset in production: Only the first 500 or 2000 records are evaluated.
- Ignored delegation warnings: Warnings were visible in dev environment but not fixed.
- Different permissions or environments: Users may have restricted access in production.
Because of these factors, apps that work perfectly during testing may return incomplete data when used with large production datasets.
