Hi All, I was wondering if it is possible to build a value by combining a charachter and variable. We have site codes for each rep, and I have built a report but instead of duplicating it for each reps site code I just want to use the below formaula, however I need to swap out "LM01" with GACTX.USER somehow so that it reads DLM01 without typing it manually. LM01 represents my usercode so when each rep looks at the report it will pull info based on their user code (GACTX.USER)

[STO]STOFCY = 'DLM01'|[STO]STOFCY = 'JLM01'| [STO]STOFCY = 'CLM01' - Current Formula

I want

[STO]STOFCY = 'DGACTX.USER'|[STO]STOFCY = 'JGACTX.USER'| [STO]STOFCY = 'CGACTX.USER' - HOW DO I DO THIS?

Thank you.