Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution
Some formula explanation is below
IF [PMID_Num] = 0 &&
isEmpty([Row-1:PMID_Num])
THEN 1
ELSEIF [PMID_Num] = 0
THEN [Row-1:PMID_Group]+1
ELSE [Row-1:PMID_Group]
ENDIF
Since we know that each new group starts with 0, we start our IF statement by checking if the New Group starts with 0 AND if the row before it is 0 which is basically initialize the starting number to be 1 by conditioning THEN
We check again with IF statement for the NEXT new group that starts with 0
Then we increment each row before the PMID_Group by 1, so now it is Group 2 and so on.
I also included comments in my solution. Have fun exploring!
Think I resolved it. You can use the ReplceChar expression in the formula tool.
Turned the solution as a guide to finish this challenge