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

column

Floating-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)

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.