Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)>})
try this,
if(len(adhoc_Lanid)>0,count(adhoc_Lanid))
so it is
Count({<Lanid={">0"}>} Lanid)
and
Count({<Adhoc_Landid={">0"}>}Adhoc_Lanid)
maybe Need a distinct?
regrads
Hi Aparna,
Thanks for u r valuable response but inside i want restrict on field 'period'
period: List box
Can you pls elaborate, should period be restricted to a value or string?
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)>})
maybe this:
=count( {< MonYY=, Adhoc_Lanid = {"=Len(Adhoc_Lanid)>0"} >} Adhoc_Lanid )
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 ..
May be this, where Adhoc_Lanid = {"*"} will exclude all null values in Adhoc_Lanid field....
'Ad-hoc Users : ' & Count({<MonYY=, Adhoc_Lanid = {"*"}>} Adhoc_Lanid)
Hi Sunny,
Thanks for your valuable assistance
Thanks,
Ravi