Subtract / Operator Layer

Perform element-wise subtraction between numeric columns or subtract a constant value from a column. Similar to pandas df['A'] - df['B'] or df['A'] - 5, or numpy's subtract operation.

Mathematical form: $y_{i} = x_{i} - v$ for constant subtraction, or $y_{i} = x_{i} - z_{i}$ for column subtraction, where $i$ is the row index.

Common applications:

Calculating differences (current - previous)
Computing discounts (price - reduction)
Finding deviations from baseline
Time series analysis (year-over-year changes)
Cost adjustments (gross - deductions)

Table

SelectLeft

column

The primary column for subtraction operation. Must be numeric type. Forms the minuend (number being subtracted from) in the operation (e.g., total price, current value, starting amount).

SelectRight

oneof

Integer

Value

i64

64-bit signed integer constant to subtract. Range: -2^63 to 2^63-1. Examples:

100 for fixed deductions
-50 to effectively add 50
365 for year offset calculations The operation performed is: column_value - this_value

UnsignedInteger

Value

u64

64-bit unsigned integer constant to subtract. Range: 0 to 2^64-1. Suitable for:

Removing quantity counts
Inventory adjustments
Fixed positive deductions Note: May cause underflow if result becomes negative

Float

Value

f64

64-bit floating-point constant to subtract. Provides about 15-17 decimal digits of precision. Common uses:

Percentage deductions (subtract 0.05 for 5%)
Price adjustments
Scientific calculations
Statistical operations (removing means)

Column

Other

column

The second column for element-wise subtraction. Must be compatible numeric type with SelectLeft. Common pairs:

Current - Previous values
Actual - Predicted measurements
Gross - Tax amounts
Maximum - Minimum readings

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.