community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Calculating with rows of data dynamically

Highlighted
Meteor

Hi! I have a simple gross margin calculation  as set out below (i.e. Gross profit divided by sales). I would use a multi row formula to calculate it, but sometimes I have several months or even weeks of data presented in fields, which would mean that I have to write down a formula for each period separately. Is there a way to make it more dynamic? e.g. determine how many periods there are and then calculate a period specific gross margin at once?

 

Thanks a lot!

 

Problem:    Desired outcome  
         
         
Name201520162017 Name201520162017
Sales1005020 Sales1005020
Gross profit30305 Gross profit30305
     Gross margin0.30.60.25
         
Quasar

Here is the sample workflow for your case. Hope this is helpful. 

 

workflow.PNGWorkflowResults.PNGResults

Meteor

thanks! this works great

Labels