Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

phoebe_90
8 - Asteroid

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:

Customer0-30 DAYS31-60 DAYS61-90 DAYS91-120 DAYS
A100   
B 200  
C  300 
D   400

rate: 0.5

Output data: value*rate

Customer0-30 DAYS31-60 DAYS61-90 DAYS91-120 DAYS
A50   
B 100  
C  150 
D   200
1 REPLY 1
Gaurav_Dhama_
9 - Comet

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.


image.png

 

Labels