Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multi Row formula failing

srikant
7 - Meteor

if [Person_Org_Number]==[Row-1:Person_Org_Number] then [Product_Sequence] =[Row-1:Product_Sequence]+1 else 1 endif 

 

( value for person_org_num = 100 ) , product_sequence = 1 ( default ) . i am testing just two rows ( all defined as Integer )

3 REPLIES 3
Aguisande
15 - Aurora
15 - Aurora

I believe you should remove the variable assignment: "[Product_Sequence] =" following the THEN clause

 

Remember, that assignment is "transparent" and will be done to the variable used in the Multi-Row formula.

Best,

_AG_

srikant
7 - Meteor

Ok.I changed it still same issue

 

if [Person_Org_Number]= [Row-1:Person_Org_Number] then [Row-1:Product_Sequence]+1 else 1 endif

 

Person_Org_Number Product_Sequence 
100                             1                             
100                             1
100                             1 

 

I wanted the result to be 

Person_Org_Number Product_Sequence 
100                             1                             
100                             2
100                             3 

srikant
7 - Meteor

I was using GROUP by incorrectly as well besides the issue you helped me correct . Thanks

Labels