Add a currency code to a numeric field depending on value stored in another field

I wonder who could help em with this. I require the 3-letter currency code for the Column 'Amount' to be based on the code entered in a field called projects.project_currency.

projects is one of the tables in the query and I even brought the field project_currency next to amount, but I would like to see the 3-letter code with the amount as in KHR 1,000.00 rather than next to it and because the currency changes with each project, I cannot just write KHR in the section 'currency code' of the column configuration.


Hi chakana,


doesn't help you?

Yes. It does the trick!
Thank you @Istvan for helping me out :slight_smile: