Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'}>}
,'|') & ')'
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.
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,'|') & ')'