Need variable value in decimal upto 3 decimals

[jai_kumar2 (jai kumar)]

iam extracting minimum value from the table using this

but iam getting value in roundof like lets say from the below list the minimum value is 110.011

but the variable output is 110

can someone help me to get value with upto 3 decimals

Thanks in advanec

[supermanPunch (Arpan)]

Hi @jai_kumar2 ,

Instead of CInt , use CDbl in the expression.

CDbl(row(0))

Let us know if it doesn’t work.

[jai_kumar2 (jai kumar)]

Thanks it Worked

But, iam getting like this “110.0118375905” as variable value

any possibility to get like this upto 3 decimal “110.011”

[supermanPunch (Arpan)]

@jai_kumar2 ,

Try the below :

Math.Round(CDbl(row(0)),3)

[jai_kumar2 (jai kumar)]

but how to use this ?

[Rahul_Unnikrishnan]

Hello @jai_kumar2

Did you tried the format value activity?

https://docs.uipath.com/activities/docs/format-value

How to use Format Value activity in UiPath to format Date, Number, Currency & Percentage ?| UiPath

Thanks

[supermanPunch (Arpan)]

@jai_kumar2

but how to use this ?

@jai_kumar2 ,

In the expression itself.

dtRow.AsEnumerable.Min(Function(row)Math.Round(CDbl(row(0)),3))

[Gokul001 (Gokul Balaji)]

Hi @jai_kumar2

How about this expression

dtRow.AsEnumerable.Min(Function(r) r(0).ToString.Substring(0,r(0).ToString.IndexOf(".")+4))

Regards
Gokul

[jai_kumar2 (jai kumar)]

Thank you all for your fast response

Regards
Jayakumar

[Gokul001 (Gokul Balaji)]

@supermanPunch

dtRow.AsEnumerable.Min(Function(row)Math.Round(CDbl(row(0)),3))

@jai_kumar2

In this expression the result would be like in below. Can you confirm that your output needs like the below one.

Input value will round of

Input → 110.0118375905

Output → 110.012

Regards
Gokul