Looking for some help with the Multi-Field Formula tool in Alteryx. I am trying to apply a calculation to multiple columns.
Example:
Data is structured in columns. I need to calculate (multiply by 0.5) to get 50% of the value listed in each column.
| ID | Description | A | B | C | D | E | F |
| 74521 | Mickey M. | 500 | 500 | 500 | 500 | 500 | 500 |
| 72673 | Minnie M. | 1000 | 2500 | 600 | 4400 | 1200 | 300 |
| 77342 | Goofy | 100 | 420 | 640 | 1200 | 346 | 232 |
| 75932 | Donald D. | 1410 | 3240 | 822 | 642 | 2410 | 360 |
| 74385 | Daisy D. | 100 | 100 | 100 | 100 | 100 | 100 |
I am expecting the following result:
| ID | Description | A | B | C | D | E | F |
| 74521 | Mickey M. | 250 | 250 | 250 | 250 | 250 | 250 |
| 72673 | Minnie M. | 500 | 1250 | 300 | 2200 | 600 | 150 |
| 77342 | Goofy | 50 | 210 | 320 | 600 | 173 | 116 |
| 75932 | Donald D. | 705 | 1620 | 411 | 321 | 1205 | 180 |
| 74385 | Daisy D. | 50 | 50 | 50 | 50 | 50 | 50 |
Can someone help me with the syntax on how to configure the tool for this type of result? I am new to this tool, and would appreciate the help.
Thanks!
