Floor / Manipulation Layer
Compute the floor (largest integer less than or equal to x) of floating-point values. Similar to numpy's floor() or R's floor().
Mathematical form:
Examples:
- 3.1 → 3.0
- 3.9 → 3.0
- -3.1 → -4.0
- -3.9 → -4.0
Common applications:
- Complete period calculations (11.8 months → 11 months completed)
- Guaranteed minimum levels (98.7% → 98% assured)
- Available inventory counts (145.9 units → 145 units confirmed)
- Completed service intervals (3.7 cycles → 3 cycles finished)
- Actual capacity utilization (87.5% → 87% achieved)
- Earned benefit calculations (2.8 years → 2 years qualified)
- Distance-based tier calculation (5.7 miles → 5 miles tier)
- Revenue recognition (quarterly progress: 2.9 → 2 quarters)
Table
0
0
Table
Transforms
[, ...]Select
columnFloating-point column to floor. Common scenarios:
- Completed unit tracking (4.7 units → 4 units finished)
- Actual usage calculation (8.9 hours → 8 hours logged)
- Minimum threshold verification (95.8% → 95% confirmed)
- Progress measurements (3.8 stages → 3 stages completed)
- Realized quantities (234.9 → 234 units available)
AsColumn
nameName 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.