Alteryx Analytics Hub

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

Create a new row by multiply one row with a number

esun1028
5 - Atom

Greeting everyone,

 

I have a data set that looks like below

District2021202220232024
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.

2 REPLIES 2
DavidP
16 - Nebula
16 - Nebula

Hi @esun1028 

 

Something like this perhaps?

 

DavidP_0-1611648662104.png

 

esun1028
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!

 

Labels