I'm trying to create a formula field that returns a number. The source of the field is a text value such as the following examples.
0.0.004.0
1.24.004.0
3.336.004.0
4.672.002.0
The goal is to store the values in bold above in the formula number field. I believe this is possible with a couple text functions (Begins, Find, Left and Right) wrapped in a Value function to return the number represented by the text highlighted above.
Can you solve this?