LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jchartrand

I am working with a set of data and I would like to use a function similar to CEIL that can be applied to decimals.

Here is a sample set of data...

Field1
0.1061
0.1585
0.1178
0.0906


I would like to round each number up to the nearest thousandth. In excel, you are able to apply a a significance to the function so it knows where to apply the ceiling function (eg. =CEILING(A2,0.001). The CEIL function in lavastorm is programmed to INT outputs. I need the output to be...

Field1
0.107
0.159
0.118
0.091

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: prasmussen

You can also use the round function in a filter node. The -3 specifies round to 3 decimal places and the 1 specifies to round up. i.e.

emit 'field1', 'field1'.round(-3,1) as "rounded"

Of course, this assumes you want a simple rounding, not exactly like the CEIL which let's you specify increments such as .005.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jchartrand

Creative, but that also rounds up unwanted situations.

Example:
.106 becomes .107 in both of your solutions.