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!
