Help

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

Topic Labels: Formulas
702 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Stephen_Joslyn
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

0 Replies 0