Select last string form an Array Rollup - Everything after last comma, up to and including 2 digits after the decimal point

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!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.