This content has been marked as final. Show 3 replies
I tried to put the code in a formula as suggested. In the property of the field under calculation/formula, however is does not like the || concatenation symbol.
:block1.ALLOC_XFER_AGENCY_ID '||':block1.BUREAU_CODE '||':block1.BEGIN_AVAIL_DATE_DUMMY '|| ':block1.END_AVAIL_DATE_DUMMY '||' :block1.AVAILABILITY_CODE '||' :block1.FUND_GROUP '||' :block1.SUFFIX
Remove the Quotation Marks from your formula code. This makes your concatenation operator a literal string instead of an operator.
:block1.ALLOC_XFER_AGENCY_ID || :block1.BUREAU_CODE || :block1.BEGIN_AVAIL_DATE_DUMMY || :block1.END_AVAIL_DATE_DUMMY || :block1.AVAILABILITY_CODE || :block1.FUND_GROUP || :block1.SUFFIX