Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
1062 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