Reciprocal / Operator Layer

Calculate the multiplicative inverse (1/x) of values in a column. Similar to numpy's reciprocal() or R's 1/x operation. Returns floating-point results for precise division.

Mathematical form: $y_{i} = \frac{1}{x _{i}}$ where $i$ is the row index.

Common applications:

Rate inversions (speed to time-per-unit)
Frequency to period conversion
Odds to probability conversion
Resistance network calculations
Spring constant inversions
Focal length calculations

Note: Values of zero result in null outputs to avoid division by zero errors. Results may have high precision requirements for small input values.

Table

Select

column

The numeric column (Select) to invert. Common scenarios:

Speed (60 mph → 1/60 hours per mile)
Rates (5 per day → 0.2 days per occurrence)
Proportions (0.25 → 4.0)
Scaling factors (2x → 0.5x)

Must be non-zero for meaningful results

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.