Normalize Multiple Features

Trying to normalize multiple features with the Multi-Field Formula tool with the following expression (that throws an error):

([_CurrentField_] - Min([_CurrentField_])) / (Max([_CurrentField_]) - Min([_CurrentField_]))

Is there a way to make this work?

Accepted answers

You can use the Dynamic Select to do the same and then a combination of Transpose and Crosstab to make this dynamic. Example attached.

The Min and Max functions in the formula tool (and multi-field formula) will only return result from a list of values not from a referenced variable

Min(10, 20, 30)

In order to calculate, you will need to use the Summarize tool and append these to your data

That's unfortunate, thanks for the information.