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!