Auto Code Generation

Hi all-

I'm trying to automatically create budget codes after a new expense has been entered via input grid on a UX page. Overall, I'm having trouble generating a numerical sequence after the other parts of my concatenated code. I've so far been using RANK(1, DESCENDING, SEQUENTIAL) but having it skip by 15 every line.

Screen Shot 2022-07-28 at 3.42.00 PM.png

 

Also, after these expenses are sent through, how can I add on to the last number instead of referencing the same sequence again and again?

 

The help is much appreciated, thank you!

Tagged:

Comments