Totals from a field that includes a range

Topic Labels: Formulas
526 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I have a field that includes a number range for each record: “5-10”, “15-20”, etc. On another table, I would like to do a rollup that adds together all the first and last numbers in those ranges, displaying “20-30” essentially. Is there a rollup formula that can find the first and last numbers in a range?

The only thing I’ve thought of so far is separating that range into 2 fields and then combining them into the other table with a concatenate, but I’m hoping there’s a solution that keeps the range in a single field

0 Replies 0