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?
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
Formula used:
SUBSTITUTE(
Name,
LEFT(
Name,
FIND(
"*",
Name
)
),
""
)
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*4, 70895-0*2, 53429-0*2
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*4, 70895-0*2, 53429-0*2
Hm, okay. Could you share screenshots of the relevant tables and fields please?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.