How can I use the tool to multiply all the existing data by the same value

phoebe_90

How can I use the tool to multiply all the existing data by the same value and then display the result of the calculation in the original data location？

For example，

Existing data:

Customer	0-30 DAYS	31-60 DAYS	61-90 DAYS	91-120 DAYS
A	100
B		200
C			300
D				400

rate: 0.5

Output data: value*rate

Customer	0-30 DAYS	31-60 DAYS	61-90 DAYS	91-120 DAYS
A	50
B		100
C			150
D				200

Gaurav_Dhama_

You can use multi field formula for this.

1. Select all the Numeric fields, including dynamic or Unknown Fields.
2. Write in the formula [_CurrentField_]*0.5. 0.5 is your rate here.
3. Uncheck Copy Output Fields and Add, to update the current fields.