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

Ask the Community Get Answers
1

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)

returns:
ABC-2022-2}

I expected it to return:
ABC-2022-0002

2

try below

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

Look like the case number is a numeric field.

Regards,
Sunny Singla
ssingla1985@gmail.com

2 Likes
3

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.