hi every one i have some valus whih is representing in the precentage formate example 1)908743.2% and some other like 2)23% it was data population in grid field my query was if the value contain length of 2 then need to print asit is but if it was more that length of 2 like i shown in example 1 it should show only 2 digit value
if value was 33% i want show same 33 %
if the value was like 98567.23% i want like 98%
note : there is no fixed length for the number which display on grid
Discussion posts and replies are publicly visible
Try left(split(ri!text, ".")[1], 2)
Hi,
I got the question like this...So, If you get 2 digit number like 33% it should print 33% only but more that 2 digit like 234.66% or 324.22% you should get 23% or 32% right?Like which ever the number you are having you should get first 2 digits only?If it is the case then the 33% or 98567.23% is text the use like [2] and concat with %
thanks it works