Hello friends, i m getting wrong output for the rounding of the number to 2 decimal Places, any one know why it is so

[aslam_ali1 (aslam ali)]

Actually for some number it works and for some number not
eg:123.429 gives o/p 123.43
but 123.425 gives output as 123.42, it should be 123.43

i have attached the output of excel below

Thanks in advance…

[sasi_poosarla (sasi p)]

@aslam_ali1

123.425

[rlgandu (Rajyalakshmi Gandu)]

@aslam_ali1

Assign activity:
Left: roundedValue
Right: Math.Round(Double_var,2,MidpointRounding.AwayFromZero)

[lrtetala (Lakshman Reddy)]

@aslam_ali1

[aslam_ali1 (aslam ali)]

Thank you @rlgandu for the quick response

Still im not getting the Output by using that expression.

[rlgandu (Rajyalakshmi Gandu)]

@aslam_ali1

Assign activity:
Left: roundedValue
Right: Math.Round(Double_var,2,MidpointRounding.AwayFromZero)

[aslam_ali1 (aslam ali)]

Thk you
Working!!!

[lrtetala (Lakshman Reddy)]

@aslam_ali1

You can try this also

Math.Ceiling(123.429 * 100) / 100

[aslam_ali1 (aslam ali)]

Thank you @sasi_poosarla it is working

Thanks for the quick response!!!

[sasi_poosarla (sasi p)]

You are Welcome…

Cheers