Add alphanumeric column

[rogersm01]

I want to add a simple year and period column to an output but it must be in the format of 2023P08. I thought just adding as a V_String would be ok but I keep getting 'Error: Formula (11): Parse Error at char(0): An operator must be between operands (Expression #1)'

How best to add this in?

Thanks

[Luke_C]

Can you share your formula?

[Qiu]

@rogersm01 
The best guess is that you are trying to "add"? two different data type.

[binuacs]

@rogersm01 Looking for something like the one below?

[rogersm01]

thanks for your help - much appreciated

[DenisZ]

Numeric and string fields cannot be joined alone. Since you are looking for a P in the middle you would need to covert your year and month to string fields using ToString([Name]) and then add a P in " ". 

Hope it helps