We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Counting rows and then dividing a value

NY2BOS
7 - Meteor

Hello all I'm looking to allocate a number based on the the amount of rows in a specific field 

For example:
I get DOG TOTAL:$50

 

My rows should show 
NAME     TYPE     VALUE

DOG1      DOG     $10

DOG2      DOG     $10 
DOG3      DOG     $10
DOG4      DOG     $10

DOG5      DOG     $10

 

so for every type dog the total should be spit evenly between all the values even if I add 5 more rows it should recalculate to $5/Name 

 

Thank you in advance 

 

 

2 REPLIES 2
cjaneczko
13 - Pulsar

I dont know how your data is structured but this should do it.

 

image.pngimage.png

aatalai
15 - Aurora

Could you use the summarise tool to calculate average grouped type and then join the results with the starting data set joining type, fewer tools

Labels
Top Solution Authors