How do I use the right() formula in a text editor?

Hi, I am trying to create a formula in knack using the right formula, but it doesn’t seem to work. I’m concatenating a few leading 0’s, then taking the last 4 digits. The formula is only picking the right most character instead of the last 4, and then leaving the closing brace on for some reason. Any help is appreciated, what am I doing wrong here?

My formula is:
ABC-formatDate({Date & Time of Incident}, YYYY)-right(0000{Case Number},4)


I expected it to return:

try below

ABC-formatDate({Date & Time of Incident}, YYYY)-right(0000right({Case Number},4),4)

Look like the case number is a numeric field.

Sunny Singla


Thank you this worked! You are also correct, the case number is a numeric field. I had tried to see if there was a to cast the numeric field to a string but I didn’t see anything in the function dropdown, so I didn’t think I needed to do so.