How to segregate a field value into two without changing edit script ?

[shekhar_analyti]

Hi All ,

I have a field Rating . Rating has following values

Rating

2/5

1/3

5/10

5/5

I want to do calculation like 2 + 5/2 , 1+3/2 , 5+10/2 ..etc . I want to achieve this on UI . I do not want to alter edit script .

Thanks & Regards

Shekar

[shekhar_analyti]

=Replace(Rating, '/','+') / SubField(Rating, '/',1)

Or,

=$(=Replace(Rating, '/','+')) / SubField(Rating, '/',1)

Above is Not working

[tresesco]

Without selecting a single value, $ expansion solution would not work. You could find alternate solution using various string-functions, like - index(), textbetween(), mid().... However, with such variations, there would not be a major performance difference in UI. Hence, you can stick to subfield() solution.