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
=Replace(Rating, '/','+') / SubField(Rating, '/',1)
Or,
=$(=Replace(Rating, '/','+')) / SubField(Rating, '/',1)
Above is Not working
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.