Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Efficiently Divide Multiple Columns By Fixed Number

kubikbr
6 - Meteoroid

Working with bi-weekly payroll data and have used the generate rows formula to create 14 rows...that will eventually represent daily payroll amounts & hours. Looking to see if there is an efficient way to divide Columns E-AF by 14? Would like to avoid creating 28 separate formula tools/equations.

 

Thanks

 

1 REPLY 1
CoG
13 - Pulsar

Have you tried the Multi-Field Formula Tool?

Screenshot.png

Labels