Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi,
Try this expression
=Sum(Aggr(Count({<Exec_RunDate={"<=$(=Date(Today(), 'YYYY-MM-DD'))"}>}DISTINCT Exec_TestID), lvl_id))
Regards,
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.
yeah..jagan .
still waitng for data need to chk .den i will close.