Record ID and multirow formula

[ohruud]

Hi, 

I am tryng to produce a record id that is based on grouping. However, the grouping function in the multi-row formula does not  do the trick. 

So the issue is:  A field contains for example the same value (String function) for 5 rows. I would like all those 5 rows to have the same record ID until next rows come. then I would like +1. 

1

1

1

2

2

2

2

etc. 

I tried this formula, but it did not work : IF ISNULL([Row-1:Record ID]) THEN 1 ELSEIF [Question]!=[Row-1:Question] THEN [Row-1:Record ID] + 1 ENDIF

Thanks

[ohruud · Accepted solution]

I solved it.  I Created a record ID and made the following formual: IF [Question]!=[Row-1:Question] then [Row-1:RecordID] +1 else [Row-1:RecordID] endif  🙂