Increasing protocol number with date

hi guys i have this code here that steve gave on my last post but i’m trying to solve it it’s only adding up to the first record and not the last

CONCATENATE(
  RIGHT(
    CONCATENATE(
      "0000",
      (
        NUMBER(
          ANY(
            TOP(
              SORT(
                SPLIT(
                  SUBSTITUTE(
                    CONCATENATE(
                      SELECT(
                        table[column],
                        ENDSWITH([column], ("/" & YEAR(TODAY())))
                      )
                    ),
                    ("/" & YEAR(TODAY())),
                    ""
                  ),
                  " , "
                ),
                TRUE
              ),
              1
            )
            + LIST("-1")
            - LIST("")
          )
        )
        + 1
      )
    ),
    4
  ),
  ("/" & YEAR(TODAY()))
)

can @Steve or someone else save me :fearful: