Exp not working

[soniasweety]

Hi all,

I am using below expression its showing ok but the result is not coming.

if(only({<JNum={">=$(=vStartDate)<=$(=vEndDate)"},

[RC]={'IN'},[Inl]={'Out'}>} [ID])=0,'Not',[ID])

but  if I use this  its working fine enough

only({<JNum={">=$(=vStartDate)<=$(=vEndDate)"},

[RC]={'IN'},[Inl]={'Out'}>} [ID]) 

if I  add the  IF condition its not working  what is the issue?

[prma7799]

I think you missed else part ..

[soniasweety]

No,

ID is else part

its there  'Not',[ID])

[prma7799]

Then you should use here aggregate function

Try this..

if(only({<JNum={">=$(=vStartDate)<=$(=vEndDate)"},

[RC]={'IN'},[Inl]={'Out'}>} [ID])=0,'Not',Count([ID]))

[soniasweety]

no PM.

it will give me the  1,1,1,1  like that  but I want to see that value    count it will not work

[Anil_Babu_Samineni]

Only returns only one values has been allocate else it will return Null. So, To over come this, Perhaps this may do job

if(Count(Aggr(only({<JNum={">=$(=vStartDate)<=$(=vEndDate)"},[RC]={'IN'},[Inl]={'Out'}>} [ID]), Field))=0,'Not',[ID])

[soniasweety]

its not working anil,

[Anil_Babu_Samineni]

Yes, I know that . Where are you trying this? As i already stated it should not be Only. Can you explain your needed?

[soniasweety]

hmm,

I am using same exp in  kpi object its working

when its come to   straight table its not working.

[Anil_Babu_Samineni]

You have to cover all Dimension to aggregate functions like

if(Count(Aggr(only({<JNum={">=$(=vStartDate)<=$(=vEndDate)"},[RC]={'IN'},[Inl]={'Out'}>} [ID]), Dim1, Dim2, Dim3))=0,'Not',[ID])