Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

Multi Row Formula

Rhaldhar
8 - Asteroid

Hi All,

 

I am expecting the below result according to the input A to B columns. Result required as coming in columns G on basis of formula F.

I need the result same after using multi row formula tool. however, it is not coming.

Please let help me to get the result.

 

Name should be same in Column A and in B should me 1 and 4 then C value will sum other wise D.

 

 

 

4.png

 

 

Thanks in advance.

 

Rajeev

3 REPLIES 3
rzdodson
12 - Quasar

@Rhaldhar is this what you are looking for?

 

Solution.png

Rhaldhar
8 - Asteroid

Hi @rzdodson  thanks for looking the issue.

 

the result should be like below. yellow highlighted sum value (count 1 + 2) of Geeta and Mohan should be in column G, for Geeta - (876+981)=1857 and for Mohan- (200+562) = 762, as shown in below screen.  

5.png

 

apathetichell
18 - Pollux

I'd use a summarize tool and a join - not a multi-row.

Labels