次に示すシナリオでは、動的に計算される範囲値でのレコードの操作方法を説明します。
DEFINE CustomerTotals AS SELECT SUM(SalesAmount) AS Total FROM SaleState GROUP BY CustomerKey ; DEFINE Range AS SELECT MAX(Total) AS MaxVal, MIN(Total) AS MinVal, ((MaxVal - MinVal)/10) AS Decile, MinVal + (Decile*9) AS Top10Pct FROM CustomerTotals GROUP ; RETURN Result AS SELECT SUM(SalesAmount) AS Total, Total - Range[].Top10Pct AS Diff FROM Range GROUP BY CustomerKey HAVING Diff > 0