Help

Help in counting integers within a rollup field array

Topic Labels: Formulas
806 3
cancel
Showing results for 
Search instead for 
Did you mean: 
corb1
6 - Interface Innovator
6 - Interface Innovator

I have a list of unique ID+count information in a rollup field. See sample data below.

16389-0*4, 70895-0*2, 53429-0*2, .....

Everything before the * is an ID, and the integer following the * is a count for that ID. I would like to strip everything prior to the star, leaving:

4,2,2,....

Then I'd like to sum those values.

Is that possible?

3 Replies 3

You'll need to add a formula field to your data table that cleans up the data for you, and then use a rollup field with `SUM(values)` in the other

Screenshot 2023-02-13 at 12.09.36 PM.png

Screenshot 2023-02-13 at 12.09.32 PM.png

Formula used:

SUBSTITUTE(
  Name,
  LEFT(
    Name,
    FIND(
      "*",
      Name
    )
  ),
  ""
)

  

Link to base

corb1
6 - Interface Innovator
6 - Interface Innovator

This is good for single elements (like you have above in your Name column). As follows:

16389-0*4

70895-0*2

53429-0*2

 

My issue is I have an array of data elements as follows:

16389-0*470895-0*253429-0*2

 

 

Hm, okay.  Could you share screenshots of the relevant tables and fields please?