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

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