Export results of calculated field

I have created a form that contains some fields which, when concatonated result in the unique identifier. It works great and the user can see the identifier on the form as they use it. However, I would like to have this calculated field exported in the CSV file and can't work out how to do it. I know that I could work with the CSV file in excel to recreate the calculated field, but for my users, it would be preferable if they could see it as a column in the CSV file.

I have tried referencing the calculated field as a note, but the exported CSV file still doesn't contain the information.

Can you share a sample form for this? The Note question type does not accept user input.

When you use calculate field, the result is saved as a column.