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

[Chanty4u]

not for level id  jagan,

For example  i hve level id's  41 and  54 and 55

exec_testid     for  41  is  1

for  54  is  3

for  55  is   1'

so total testcase planned is  1+3+1=5

for this exp it shwng 3

=Count({<Exec_RunDate={"<=$(=Date(Today(), 'YYYY-MM-DD'))"}>}DISTINCT Exec_TestID)

[jagan · Accepted solution]

Hi,

Try this expression

=Sum(Aggr(Count({<Exec_RunDate={"<=$(=Date(Today(), 'YYYY-MM-DD'))"}>}DISTINCT Exec_TestID), lvl_id))

Regards,

jagan.

[jagan]

Hi Suresh,

If you got the answer please close this thread by giving Correct & Helpful answers to the posts which helps you.

Regards,

jagan.

[Chanty4u]

yeah..jagan .

still waitng for data need to chk   .den i will close.