Skip to main content
raghavak0001
raghavak0001
October 9, 2023
Question

number splting

  • October 9, 2023
  • 3 replies
  • 0 views

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

    3 replies

    mageshwarang0609
    mageshwarang0609
    October 9, 2023

    Try left(split(ri!text, ".")[1], 2)

    raghavak0001
    raghavak0001Author
    October 9, 2023

    thanks it works 

    tejak2639
    tejak2639
    October 9, 2023

    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 %

    Terms & ConditionsAccessibility statement