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

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels