Round off to a decimal number

[adishjain]

Hello All,

I am trying to round on one decimal number into calculation. suppose I am multiplying 160.31 x 855 x 0.1= 13706.505, and I want it as 13706.51,
now suppose VarAmount=13706.505, RoundOfLimit=2
I have used math.round(VarAmount, RoundOfflimit) in which RoundOfLimit comes from config file. I have set it to 2. I want round of decimals up to two decimal numbers. Please suggest how to do it.

[raja.arslankhan]

@adishjain
Assign activity:
VarAmount = 13706.505
RoundOfLimit = 2

Assign activity:
VarAmount = Math.Round(VarAmount, RoundOfLimit)

[rlgandu]

@adishjain

I am trying to round on one decimal number inti calculation. suppose I am multiplying 160.318550.1= 13706.505, and I want it as 13706.51,
now suppose VarAmount=13706.505, RoundOfLimit=2
I have used math.round(VarAmount, RoundOfflimit) in which RoundOfLimit comes from config file. I have set it to 2. I want round of decimals up to two decimal numbers. Please suggest how to do it.

@adishjain

Variables:
VarAmount (Double) = 13706.505
RoundOffLimit (Int32) = 2

Activities:
Assign:

• To: rounded_amount
• Value: Math.Round(VarAmount, RoundOffLimit)

Write Line:

• Text: rounded_amount.ToString

[lrtetala (Lakshman Reddy)]

Hi @adishjain

Math.Round(VarAmount*RoundOfLimit, 2)

Ex:

[adishjain]

i tried it but it is giving me 13706.50

[raja.arslankhan]

@adishjain

Assign activity:
VarAmount = 13706.505
RoundOfLimit = 2

Assign activity:
VarAmount = Math.Ceiling(VarAmount * Math.Pow(10, RoundOfLimit)) / Math.Pow(10, RoundOfLimit)

[ppr (Peter)]

@adishjain

i tried it but it is giving me 13706.50

this can happen due the internal precision and as we do see the .505 is with the last 5 within the middle and let’s not flip to 51

[adishjain]

your code is having only one decimal place, please try it with 3 decimal places. Like 123.325, then it should give as 123.33 in result

[adishjain]

but Sir, it is business requirement

[raja.arslankhan]

@adishjain did you try above one.

[ppr (Peter)]

@adishjain

it is business requirement

it is not a problem. Once we have understood the technical base we can take care of and fullfill the business requirement

[lrtetala (Lakshman Reddy)]

Hi @adishjain

Math.Ceiling(Var1 * Math.Pow(10, Round)) / Math.Pow(10, Round)

[pravallikapaluri]

Hi @adishjain

1. Read the value of VarAmount from your data source or variable.
2. Read the value of RoundOfLimit from your config file or variable. In your case, it’s 2.
3. Use the Math.Round method to round VarAmount to the specified number of decimal places (RoundOfLimit).
   VarAmount = Math.Round(VarAmount, RoundOfLimit)
   VarAmount = Math.Round(13706.505, 2)

Hope it helps!!

[raja.arslankhan]

@adishjain Try Above one it will give you desire value

[ppr (Peter)]

@ppr

it is not a problem

You can try:

MidpointRounding Enum (System)

[raja.arslankhan]

@adishjain

[adishjain]

it is giving me 13706.50

[adishjain]

yes it is working sir, thankyou so much

[adishjain]

it is working for me, thankyou

[pravallikapaluri]

@adishjain