How can I use the Multi-Field Formula tool to multiply 1-N fields by 1,000?

[hellyars]

Hi

I have a bunch of fields (columns) that need to be multiplied by 1000 to get rid of the decimals. 

I know I can setup a formula for each field, but I have a lot more fields than the example below.

Is there a way to use the Multi-Field formula to solve this simply?

	TRUCKS	CARS	PLANES	HELICOPTERS
How it is in the data set	1.123	2.345	5.455	4.651
How I want it	1123	2345	5455	4651

[Claje · Accepted solution]

Hi,

You're absolutely correct that you can use Multi_field formula to accomplish this.  The key is the option to include Dynamic or Unknown fields in this tool.

Here's an example of how to configure that tool:

[hellyars]

I am learning very quickly the Multi Field Formula tool is amazing. Thank you.