Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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