ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.

Create a new row by multiply one row with a number

5 - Atom

Greeting everyone,


I have a data set that looks like below

Site A24232526
Site B50484951
Site C65201921
Total 2160211321162122


I am trying to create a new last row with data that multiply the "Total" row with the same coefficient of 0.94.


Any suggestion of how to do it? Thanks in advance.

16 - Nebula
16 - Nebula

Hi @esun1028 


Something like this perhaps?




5 - Atom

hi @


It works perfectly. Thanks a lot!


One more question, if I need to create a new row with the data that I need to type in, how could it be achieved in Alteryx?


Thanks again for your help!