Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi ,
Check this ,
=num((sum(Complexity * E_Count) / sum({<cldes= {'TExe - IT','T Exe - MT','MT_Tep','RBD'}>}clhrs))/8,'###.##')
HTH,
Hirish
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.
is aanything wrng in exp?
Please correct it?
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.
hi jagan,
Both are nt frm same table.
we are created in script.
lik Sum(1) as E_Count
resident frm fact table?
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.
if i use abve exp the value cmg as 53175.56
and frst exp if i use its gvng 0.17?
Hi suresh,
Does it work fine?
-Hirish
both exp wrkng but how it is caluculating i cant u.stand?bcz its gvng diff values na