I've encountered an issue with customizing the appearance of a code field result within the Profile Value Layout.
While the query itself functions correctly and returns the desired result, applying custom formatting such as "[value] some text" doesn't seem to have any effect.
I attempted to use both [cb:userdata field="field_name" /] and [cb:userfield field="field_name" /] tags to call the field in another CustomHTML field, but unfortunately, neither of these solutions resolved the issue.

Issue solved by using [cb:userfield field="field_name" /] in the CustomHTML and changing "Show on Profile" from "No" to "Yes".
 

You shouldn't need a second field to append to your code field. Just be sure it's set to display on profile and use [cb:userfield field="FIELD_NAME" /] and your substitution should display with layout fine.

I need to display it in a particular location, within a Bootstrap card. Certain fields appear better using the [cb:userfield...], while others [cb:userdata field...] with parameters like "formatting div", or simply [cb_field]. Things become challenging when there's a need to set "Prepare content using CMS Content plugins" to Yes within the htmlCode field and there are combinations of userfield, userdata, and raw there. Then I have issues with the functionality of the htmlCode, like some fields work and others don't or the htmlCode field doesn't work at all. Then I have to improvise...