Hi there,
I have have a roll-up field that gives a load of values as CSV. Great. Turns out they are naturally in chronological order - Great again.
They are all variable values with sometimes variable decimal points too.
So I want to extract the last value. e.g. From this 19795.59,3909.09,6753.98,12435.720000000001
I am only looking for “12435.72”
I’ve been thinking that I can use RIGHT and FIND the last “,” and select what comes after. But I always need a number of characters to look for. Is there a way to include the range to be from the last “,” to the last “.” +2?
Thanks in advance!