Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I have handled this using substring at script level , but req is to achieve same at UI level ..
Substring future works both level either script and UI will work
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
Before discuss, can we know your intend ?
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 .
This?
=SubField(Rating, '/',1)+SubField(Rating, '/',2) /2
Hi Tresesco ,
I have used This already as well .
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)
Yeah ... actually looking for alternatives .. which should not make my existing application heavy ..