Multi Row formula failing

[srikant]

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 )

[Aguisande · Accepted solution]

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]

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 · Accepted solution]

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