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]

I have handled this using substring at script level , but req is to achieve same at UI level ..

[Anil_Babu_Samineni]

Substring future works both level either script and UI will work

[shekhar_analyti]

Hi Anil ,

Thanks for reply . Is there any other way , i am just curious to know . Because i have huge data and i do not want to take toll on performance . Please suggest

[Anil_Babu_Samineni]

Before discuss, can we know your intend ?

[shekhar_analyti]

Hi Anil ,

I have to use numeric values in field separated by '/' for calculation i mentioned . I do not want to make any change in data script .

[tresB]

This?

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

[shekhar_analyti]

Hi Tresesco ,

I have used This already as well .

[tresB]

Isn't that working? Or you are just looking for alternatives. If so try one more option:

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

Or,

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

[shekhar_analyti]

Yeah ... actually looking for alternatives .. which should not make my existing application heavy ..