Convert UI element to 1 Decimal Place

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Hi,

I have the following UI Element as shown in the Excel below:

I need to cross-check it with my Excel and if it matches then perform certain action.
I can convert my values in Excel to 1 decimal place:

Convert excel column to 2 decimal places

@Yudhisteer_Chintaram1 - Ok, please try like this… [image] Invoke Code: dt.AsEnumerable().ToList().ForEach(Sub(row) row("NW Elasthane 2DP")=Math.round(cdbl(row("NW Elasthane")),2).ToString("N2")) OR (if you want to write the output in Number format use the below…tested and working) dt.AsEnumerable().ToList().ForEach(Sub(row) row("NW Elasthane 2DP")=Cdbl(Math.round(cdbl(row("NW Elasthane")),2).ToString("N2"))) My Output [image] you can use write range and right the output to a new sheet …

I can also extract the numbers only from the UI element as solved by @prasath17 here:

Decision based on varying UI element

Hi, On a website I need to check a UI element to see if it is 0kg or near 0kg. If “YES” click “CLOSE”, if NO do another action. However, the UI element is not constant. There are some small changes in it as shown below: [open pix1] [openpix2] [openpix3] [open pix 4] [open pix 5] [open pix 6] [image] [image] [image] I am using an “Anchor” activity on the “Open:” and a “Get Text” activity on the left part. I am saving my Get Text in a “openText” variable. I splitted it using the code below…

Now I need to convert the UI element to 1 decimal place. That is I am using a “Get Text” activity and after trimming to get the Number only, I then need to convert it to 1 decimal place in order to cross-check it with my Excel.

Can someone help please?
Thanks!

[NIVED_NAMBIAR (NIVED N)]

Hi @Yudhisteer_Chintaram1
try like this

after getting the value using get text , and storing in a string,

use the below assign activity to round off

let say you had stored the get text result in input variable

assign activity

input = Math.Round(CDbl(input),1).ToString

This will round the number to 1 decimal places

Hope it helps

Regards,
Nived N
Happy Automation

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Thanks man!

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

@NIVED_NAMBIAR
The problem I am experiencing now is that sometimes the UI element is like this:

But in my Excel the value is 1.0
So it does not match. Can we transform this number to 1 dp?
That is if we have the 7.32 in the UI element, it goes to 7.3 with your code.
But if we have 1 in the UI element, it gets transform to 1.0

Can we have that?

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Hi @NIVED_NAMBIAR ,

It is not working if my value is “1.032”.
Or any value that has a zero after the decimal point, it is returning an integer.

[prasath17 (Guru)]

@Yudhisteer_Chintaram1 - could you please let us know what are the different values and the output you are looking for?

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Thanks for the help @prasath17
I tried this process:

I used an if condition to check if the UI element is in decimal place(Contains(".") or integer and convert it to 1 decimal place in both situations. It works fine with any numbers except if I have a number like “1.0” or “2.0434”, that is any number “x.0xxx”.
There it fails as it returns an integer (for ex: 2 instead of 2.0).

I am expecting something like that:

[prasath17 (Guru)]

@Yudhisteer_Chintaram1 - Please try this…

Math.round(cdbl(Item),2).ToString(“N1”))

Hope this helps…Actually clue was in your previous post, i have posted the reference link from Microsoft docs too…

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Yep. I tried this one:

Thanks @prasath17