Split a value and then make an average

[Diego_Rodriguez]

Hi there!

I have the following info from the “get an item” module:

I need to:

1. Split the text for each ", ".
2. Format the splited values into number.
3. Make an average with the results.

I’ll aprecciate so much your help, I’ve been stuck for 3 days with this!

[Emmanuel_Momoh]

there might be other ways to do this, but this worked out for me.

Create a variable using your “Text” as input, and then calculate the average using the formula in the screenshot

then you should get the result below after running

Let me know if it works