Round Off number even if data type is string

Question

Hi

I have some inquiry here whose data type is string. The conditions is to round off number to 5 decimal places. However if the content is "Price", it should be retain as is and if it is null then as is also. Below is an example.

I would like results to look like this.

Hope to hear from anyone.

Kamen

SPetrie · Accepted Answer

Try this formula if REGEX_Match([Price],".*\d.*") then tostring(round(ToNumber([Price]),0.00001),5) else [Price] endif

grazitti_sapna · Accepted Answer

Hi @KamenRider 
I have made workflow for your use case.
Hope it works for you
Thanks