Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I need to create a button , when i activate , i need the Pending & Negotiation label to be turn on.
So i using below script :-
(Pending|Negotiation)
But it does not work. Can some one advise me why ?
Paul
No, only this
Replace([Sales Stage],' ','_') as [Sales Stage]
May be ='(Pending|Negotiation)'
Hi Anil
Thank you.it work fine, like below :-
='(Pending|Negotiation|Prospecting)'
But i also have :-
Initial Communication |
='(Pending|Negotiation|Prospecting|[Initial Communication])'
Above does not work. why ?
How about this?
='(' & Concat(DISTINCT {<[Sales Stage] = {'Pending', 'Negotiation', 'Initial Communication'}>}Chr(34) & [Sales Stage] & Chr(34), '|') & ')'
Hi Anil
Still cannot work.
now it does not select any label.
Paul
Hi,
PFA
Hi Anil
How about can you advise me how to recode the label of
Initial Communication |
To Initial_Communication ?
Paul Yeo
Hi Anil
I think your is latest ver.
I open your QVW , it still not working.
May be due to I am still using Ver 9 , no budget to upgrade.
Paul
Hi Fer
Thank you , i am using ver 9 , not able to work.
Paul