RE:What wrong inmy expo?

[Chanty4u]

Hi all,

,jagan mohan rao appala,Tamil Nagaraj,,Sunny T ,Sunny k ,settu_periasamy,swuehl

i want to caluculate

1.for each exe_testId get latest exc_rundate

2.for the ex_testid and latest exc_rundate and get the exc_status

3.If exe_status ='not passed'  then count.

here is my exp

=Count

  (DISTINCT if(not IsNull(

  if(Aggr

  ( NODISTINCT

  Max({<Exec_Status  -= {'Passed'}>} Exec_RunDate)

  ,

  lvl_id, Exec_TestID

  )

  < Now()

  , Exec_TestID

  )

  )

  , Exec_TestID)

  )

can anyone help me on this?

thanks

Suresh

[Anonymous]

COUNT{exe_status ={'not passed'}(exe_testId)

TO GIVE THE EACH DIMENSION

[Anonymous]

Now() will return Timestamp

Try like Date(Now(),'YourFormat')

[Anonymous]

may be like this?

=Count(DISTINCT if(not IsNull(

  if(Aggr( NODISTINCT Max({<Exec_Status  -= {'Passed'}>} Exec_RunDate) ,Exec_TestID )  < Date(Now(),'Exec_RundateFormat')

  , Exec_TestID)), Exec_TestID) )

[Chanty4u]

no luckbalraj...

[Anonymous]

1.for each exe_testId get latest exc_rundate

2.for the ex_testid and latest exc_rundate and get the exc_status

3.If exe_status ='not passed'  then count.

=aggr(max(exc_rundate), exe_testId)    //For 1st

=if(exe_status ='not passed', count(Exec_TestID)  // For 3rd

What you want from the 2nd point? How do you want to compare exe_status & exc_rundate??

2.for the ex_testid and latest exc_rundate and get the exc_status

Try like this?

=count(aggr(max({<exe_status={'*'} - {'Passed'} >}exc_rundate), exe_testId) distinct exe_testId)

[sasikanth]

HI,

Try this

Count

  (DISTINCT if(not IsNull(

  if(Aggr

  ( NODISTINCT

  Max({<Exec_Status  ={'*'}- {'Passed'}>} Exec_RunDate)

  ,

  lvl_id, Exec_TestID ) , Exec_TestID )

  )

  , Exec_TestID)

  )

[Chanty4u]

not working sunny  and balraj

[sasikanth]

Any sample data or your app?

[Chanty4u]

my req is

Count of Exec_Status in 'Not Passed' status, this should be extracted based on System date