Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can we use 'OR' in set analysis?
Ex:
client ID='1234' or '5678'
count({$<PMT={'101'},Client_ID= {'PLESC','ESILDR'}>}trans id)
OR Same Field
sum({$<ClientId = {1234,5678}>}field)
OR different field
To be more specific what if
client ID='PLESC' or 'ESILDR'
can i be able to use the same syntax for the string as well, i have give it a try but not working?
count({<$PMT={'101'},Client_ID=?>}trans id)
what should be the syntax i shoud be using for this?
count({$<PMT={'101'},Client_ID= {'PLESC','ESILDR'}>}trans id)
It should look like:
count({<$PMT={'101'},Client_ID={'PLESC','ESILDR'}>} trans id)
/Johan
Mohit, thanks for the help it worked anyway in your expression does the '+'(PMT={'101'}+Client_ID={'PLESC','ESILDR'})
sign implies to be as 'AND'?
count(Distinct {$<PMT={'101'}+Client_ID={'PLESC','ESILDR'}>} trans id)
For AND use this operator *
Thanks for the help Mohit.