Decimal Rounding

[cemal_aydin]

Hi,

i want to round a value that is 3.35 to a value of 3.50 in the decimal rounding operation. With which function can I do this

[gustavofarias]

This is not rounding, it's another operation.

Can't you do it in the expression of the text field or variables?

[bigalex]

$V{ RoundUp}.setScale(2,BigDecimal. ROUND_HALF_UP)

[gustavofarias]

The above answer is wrong and you produce the exact same 3.35

[rmeadows]

try the above with BigDecimal.ROUND_CEILING or set the number of decimal places to 1 so that it rounds at that position.  

so

$V{ RoundUp}.setScale(1,BigDecimal. ROUND_HALF_UP)

Thanks.

[gustavofarias]

Won't produce correct answers.

above with BigDecimal.ROUND_CEILING -> 3.35

set the number of decimal places to 1 ($V{ RoundUp}.setScale(1,BigDecimal. ROUND_HALF_UP)) -> 3.4

 

What is asked is not a rounding operation, so using rounding is unlikely produce a correct answer.

[jgust]

I had this problem when I worked in the newspaper industry.  We used a pagination program that would round up on the 10th of a point.  The simple solution is to add the threshold difference to the number you are rounding up.

If .35 is your minimum threshold then you can add .15 to the number (.5-.35=.15) giving the knowledge that .5 is the universal round-up number.