Use case: We want to create a basic Commissions report based out of the Deals module. However, what if we have differing commission rates based on different Deal sizes?
Formula columns in Pivot or Summary tables are quite limited, so, you will want to run some conditional logic in your formula columns.