Grouping Projects by Marketing Parent Name Rounds

[LutzWo]

Hello!

Previously I'd been tasked to group parent names by R1, R2, R3, etc. Now they've moved the goal post and want me to edit the report to count how many projects go up to R1, up to R2, up to R3, etc.  I've started the expression:

IF((CONTAINS({parent}.{name},"R1"),(NOTCONTAINS({parent}.{name},"R2")),(NOTCONTAINS({parent}.{name},"R3")),(NOTCONTAINS({parent}.{name},"R4")),(NOTCONTAINS({parent}.{name},"R5")),(NOTCONTAINS({parent}.{name},"R6")),(NOTCONTAINS({parent}.{name},"R7"))),"R1")

Do I need to do this for all over the rounds as a single expression? If so, how do I do that? Or can I write multiple expressions, one for each round? I'm not even sure if the expression I wrote is correct! Any input/help would be greatly appreciated!

Thank you!

[SuryaLakhani]

Hi @LutzWo ,

I think a nested IF statement will work here, something along these lines:

IF(CONTAINS("R1",{parent}.{name}),"R1",IF(CONTAINS("R2",{parent}.{name}),"R2",IF(CONTAINS("R3",{parent}.{name}),"R3",IF(CONTAINS("R4",{parent}.{name}),"R4",""))))

Make sure the number of IF matches the ")" at the end.

[LutzWo]

Thank you for your response!

That was my previous solution, but the problem is the projects repeat in the report due to having multiple rounds. So a project with 7 rounds will show up in all sections. Is there a way to remove the repeats? For a example a project with 7 rounds will ONLY appear in the R7 section of the report?