Formula returning extra character

[Katy_Richards]

Hi

I have a formula that compares a rollup to a text field and then returns any new additions to the rollup. However it seems to be returning an extra character, could anyone help me figure it out please?

From this:

'Nelson Dance Festival- 2024, Royal Tunbridge Wells Dance Festival- 2024, Blackburn Festival of Dance- 2024, Dudley Festival- 2024'

I would like it to return 'Dudley Festival- 2024'

But I'm getting '4, Dudley Festival- 2024'

The formula is this:

IF(LEN(ARRAYJOIN({Rollup Festivals Entered},", "))-LEN({Static Festivals Entered})>0,RIGHT(ARRAYJOIN({Rollup Festivals Entered}),(LEN(ARRAYJOIN({Rollup Festivals Entered},", "))-LEN({Static Festivals Entered}))))

What am I missing?

[Alexey_Gusev]

---

What am I missing?

---

new element brings new separator, (+2 chars).
you can adjust your formula with -2. but I would use REPLACE instead of RIGHT

IF(LEN(ARRAYJOIN({Rollup Festivals Entered},", "))-LEN({Static Festivals Entered})>0,
  REPLACE(ARRAYJOIN({Rollup Festivals Entered},', '), 1, 2+LEN({Static Festivals Entered}),'')

[Katy_Richards]

Thank you so much for your help! With an extra ')' it worked perfectly!

IF(LEN(ARRAYJOIN({Rollup Festivals Entered},", "))-LEN({Static Festivals Entered})>0,
  REPLACE(ARRAYJOIN({Rollup Festivals Entered},', '), 1, 2+LEN({Static Festivals Entered}),''))