In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

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
14 - Magnetar

Have you tried the Multi-Field Formula Tool?

Screenshot.png

Labels
Top Solution Authors