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

[HirisH_V7]

Hi ,

Check this ,

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

HTH,

Hirish

[jagan]

Hi,

Exp:

num(sum(Complexity * E_Count) /

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

Calculates sum(Complexity * E_Count)

and then divides (sum({<cldes= {'TExe - IT','T Exe - MT','MT_Tep','RBD'}>}clhrs)/8)

What is the complexity in the expression.

Regards,

Jagan.

[Chanty4u]

is aanything wrng in exp?

Please correct it?

[jagan]

Hi,

I think syntax wise no issues.

Is Complexity and E_Count are in same table or different tables?  If they are in different tables then try

num((sum(Complexity) * Sum(E_Count) )/

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

Hope this helps you.

Regards,

jagan.

[Chanty4u]

hi jagan,

Both are nt frm same table.

we are created in script.

lik  Sum(1) as E_Count

resident frm fact table?

[jagan · Accepted solution]

Hi,

Then use this expression

num((sum(Complexity) * Sum(E_Count) )/

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

Regards,

Jagan.

[Chanty4u]

if i use abve exp the value cmg as  53175.56

and frst exp  if i use   its gvng 0.17?

[HirisH_V7]

Hi suresh,

Does it work fine?

-Hirish

[Chanty4u]

both exp wrkng but how it is caluculating i cant u.stand?bcz its gvng diff values na