Forum Discussion
Concatenation using variables
I need to have a result column in my report be a concatenation of text and conditionally, 1 or 2 addtional text 'values'. "Donor+xxxx" - in every row conditionally, if donor # from table 1 matches ...
Anonymous ,
Can you share the sample data?
Thanks,
I'm not certain the best way to share data information. Will the relationship diagram help?
Here is what I've tried to start - I'm trying to create a measure on a donor transaction table checking to see if the donor number is in the CHG table.
TestReq =
var CHG = RELATED(CHAGAS[TIDONR])
RETURN