Metric conversion interfering with imperial rounding

Using the CEILING function with the FEET conversion rounds the value to the nearest meter instead of the nearest foot, causing calculation errors.

In the Value field, enter CEILING(feet(...)) to reproduce the bug where rounding snaps to meters
In the Value field, enter CEILING(feet(...)) to reproduce the anomaly where rounding is done to the nearest meter
Switch the rounding method to Always round each task quantity and observe the impact on results
Set the Rounding Method to Always round the quantity of each task and observe the impact on the results
Adjust time and provided quantities (e.g., 0.5 h and 50 lin. ft) to isolate rounding behavior
Adjust the time and quantities entered (e.g., 0.5 h and 50 lin. ft.) to isolate the rounding behavior

Please authenticate to join the conversation.

Upvoters
Status

Planned

Board

Evalumo

Date

3 months ago

Author

Louis-Philippe Tremblay

Subscribe to request

Get notified by email when there are changes.