iam extracting minimum value from the table using this [query] but iam getting value in roundof like lets say from the below list the minimum value is 110.011 [List] but the variable output is 110 can someone help me to get value with upto 3 decimals Thanks in advanec

[image] jai_kumar2: but how to use this ? @jai_kumar2 , In the expression itself. dtRow.AsEnumerable.Min(Function(row)Math.Round(CDbl(row(0)),3))

Need variable value in decimal upto 3 decimals

Gokul001 (Gokul Balaji) September 20, 2022, 11:30am 8

How about this expression

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

Regards
Gokul

Topic		Replies	Views
Get minimum value of a variable Help excel , studio	12	3571	October 27, 2019
How to set max three decimals Studio datatable , excel , uiautomation , pdf , orchestrator , robot , activities , studio , data_scraping , question , activities_panel	9	1047	September 9, 2022
Adding Decimal upto 2 digit in whole number Studio studio , question , activities_panel	8	3305	September 6, 2021
Calculate the lowest excel value Help datatable , excel , studio , error	4	1233	October 26, 2019
Compare double and set it as minimum Studio datatable , activities , studio , variable	6	1526	October 27, 2021