Problem

What to Look For

• Whether the logic depends on previous or next rows
• Whether the data must be sorted first
• Whether the calculation is a running total, delta, or change flag
• Whether a standard Formula tool can evaluate the expression row by row without row context

Representative Example

• Flag when a customer_id changes from the previous row
• Compute amount minus previous row amount
• Build a cumulative balance across ordered transactions