How to write if() in Set Analysis

[ravikumar_iyana]

please let me know how to correct this expression

but inside i want restrict on field 'MonYY'

MonYY: List box

I am tried this = 'Ad-hoc Users :  ' & count({<MonYY=, if(Len(Adhoc_Lanid)>0,Adhoc_Lanid)>})

[Anonymous]

try this,

if(len(adhoc_Lanid)>0,count(adhoc_Lanid))

[martinpohl]

so it is

Count({<Lanid={">0"}>} Lanid)

and

Count({<Adhoc_Landid={">0"}>}Adhoc_Lanid)

maybe Need a distinct?

regrads

[ravikumar_iyana]

Hi Aparna,

Thanks for u r valuable response but inside i want restrict on field 'period'

period: List box

[Anonymous]

Can you pls elaborate, should period be restricted to a value or string?

[ravikumar_iyana]

please let me know how to correct this expression

but inside i want restrict on field 'MonYY'

MonYY: List box

I am tried this = 'Ad-hoc Users :  ' & count({<MonYY=, if(Len(Adhoc_Lanid)>0,Adhoc_Lanid)>})

[agigliotti]

maybe this:

=count( {< MonYY=, Adhoc_Lanid = {"=Len(Adhoc_Lanid)>0"} >} Adhoc_Lanid )

[Anil_Babu_Samineni]

ravi kumar wrote:

please let me know how to correct this expression

but inside i want restrict on field 'MonYY'

MonYY: List box

I am tried this = 'Ad-hoc Users :  ' & count({<MonYY=, if(Len(Adhoc_Lanid)>0,Adhoc_Lanid)>})

You can not this? Look agigliotti Response ..

[sunny_talwar]

May be this, where Adhoc_Lanid = {"*"} will exclude all null values in Adhoc_Lanid field....

'Ad-hoc Users :  ' & Count({<MonYY=, Adhoc_Lanid = {"*"}>} Adhoc_Lanid)

[ravikumar_iyana]

Hi Sunny,

Thanks for your valuable assistance

Thanks,

Ravi