Concatenating String

[vijetas42]

I have two output of project code which are string so, how can I concatenate them and make a action in select field of text box

expression is,

count(DISTINCT {<[Code]={"=sum($(vSale))/1000000 >0"},[Phase]-={'Cancelled','Complete'},

[RAG]={'G'}>}[Code])

+

count(DISTINCT {<[Code]={"=sum($(vSale))/1000000 >0"},[Display_Phase]={'Open'},

[RAG]={'G'}>}[Code])

I have tried to write action in text box as,

'('&concat(DISTINCT {<[Code]={"=sum($(vSale))/1000000 >0"},[Phase]-={'Cancelled','Complete'},

[RAG]={'G'}>}[Code],'|')&')'

&

'('&concat(DISTINCT {<[Code]={"=sum($(vSale))/1000000 >0"},[Display_Phase]={'Open'},

[RAG]={'G'}>}

,'|')&')' 

but didn't work.

Please suggest!

TIA

[sunny_talwar]

May be this

='(' & Concat(DISTINCT {<[Code] = {"=Sum($(vSale))/1000000 >0"}, [Phase] -= {'Cancelled','Complete'},

[RAG] = {'G'}>+<[Code] = {"=Sum($(vSale))/1000000 >0"}, [Display_Phase] = {'Open'},

[RAG] = {'G'}>} [Code],'|') & ')'

or may be this

='(' & Concat(DISTINCT {<[Code] = {"=Sum($(vSale)) > 0"}, [Phase] -= {'Cancelled','Complete'},

[RAG] = {'G'}>+<[Code] = {"=Sum($(vSale)) > 0"}, [Display_Phase] = {'Open'},

[RAG] = {'G'}>}

,'|') & ')'

[tresesco]

May be this:

'('&

concat(DISTINCT {<[Code]={"=sum($(vSale))/1000000 >0"},[Phase]-={'Cancelled','Complete'},

[RAG]={'G'}>}[Code],'|')

& '|' &

concat(DISTINCT {<[Code]={"=sum($(vSale))/1000000 >0"},[Display_Phase]={'Open'},

[RAG]={'G'}>}

,'|')

&')'

Note, few corrections in parenthesis and highlighted section.

[jonathandienst]

Not sure how vSales is defined  -  as liong it is not supposed to work row by row - you could try

'(' & Concat(DISTINCT {<[Code] = {"=sum($(vSale))/1000000 >0"}, [Phase] -= {'Cancelled','Complete'}, [RAG]={'G'}>} Code,'|')

& '|' &

& Concat(DISTINCT {<[Code] = {"=sum($(vSale))/1000000 >0"}, [Display_Phase] = {'Open'}, [RAG]={'G'}>} Code,'|') & ')'

Or perhaps a single expression rather than the compound one above:

'(' & Concat(DISTINCT {<[Code] = {"=sum($(vSale))/1000000 >0"}, [RAG]={'G'}> * (<[Phase] -= {'Cancelled','Complete'}> + <[Display_Phase] = {'Open'}>)} Code,'|') & ')'