RE:How it works?

[Chanty4u]

hi all,

Can anyone explain how it works?

explain the expression

am using this exp in Text Object.

Exp:

num(sum(Complexity * E_Count) / (sum({<cldes= {'TExe - IT','T Exe - MT','MT_Tep','RBD'}>}clhrs)/8),'###.##')

thnaks in advance.

Suresh

[Chanty4u]

hi jagan,

The exp was correct ....but the issue is

new:

LOAD

    Etest as Test_ID,

    Sum(1) as ECount

    Resident Fact_Table

Group By Etest;

problm wit gruop by?

[jagan]

Hi,

Check with your user about his expected value and then use whatever the expression you required.  User is the one who decides not we.

Regards,

Jagan.

[HirisH_V7]

Hi,

If you group by means the values corresponding or sub subsequent to that field will be Calculated.Based on Requirement you can fetch the result.

-HirisH

[Chanty4u]

thnx hirish..

the issue is nt with values...

my req is:-

Example:

i have Prj1       and    Prj2

Prj1:

Rer_Id   and test cases

                    1--------- 3time

                    2---------3times

                    3     -----2times

                     4-------1time

Exc-id:  exc-test

1          1

2          2

3          1

4            3

5             4

same for PRj2 also.

so wen am findng the complexicty   its counting  all PRJ1 aand PRJ2

but i need to get   for  1req how many times excuted count shud be calucluate in script?