Concatenating Fiscal Year and Accounting period as a string

[former_member714184]

Hello,

I have a request to add Fiscal year , Accounting period and RowID as one string.

Fiscal Year= 2021 Accounting period=10 Row ID=1

The request to populate the field as 2021101

But when I use concatenate function the field values are adding up as 2032

Also how do I start rowid as 00001

Thanks,

Aravind

[denis_konovalov]

I have fixed your tags, please do be more careful when selecting tags, so that your questions reach correct audience.

[ayman_salem]

try this:

=[Fiscal Year]+""+[Accounting period]+""+[Row ID]

[former_member714184]

Thanks, that worked.

[ayman_salem]

If you are ok with the answer, please accept it and close the question