Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have expression lik below
=num(
sum(Complexity)
/
(11111
sum({<desc={'Design - IT',' Design - RT'}>}hrs)
/8
)
,'##.##')
i used same formualue in straitght table nummerator and denomenator.
am getting the sum of abve /sum of below exp.
My req is--- where sum({<desc={'Design - IT',' Design - RT'}>}hrs) this value is '0' shwn in chart that corresponding values shud nt count and remaing shud be count / total of sum({<desc={'Design - IT',' Design - RT'}>}hrs) .
example: there is 47 value.. corresponig 172... the result shud be 172/408. is my result.
thnks in advance
not wrkng sudhakar
no luck......
and what output is giving insted of all use total
both are nt gvng exact values ....
Attach sample file then it would be easier to understand and provide the solution.
Regards,
Jagan.
sum( {<hrs={'*'}>}-e(hrs={'0'})hrs)
try it this one
.... hi jagan,
this exp is my expected value...but it is nt gvng
If(Sum({<desc={'Design - IT',' Design - RT'}>}hrs) > 0, Sum(Complexity)/Sum(TOTAL {<desc={'Design - IT',' Design - RT'}>}hrs))
If(Sum({<desc={'Design - IT',' Design - RT'}>}hrs) > 0 in this exprsn where 0 availble that corresponding value shud nt be summed in sum(complxity)
HI,
Try like this
If(Sum({<desc={'Design - IT',' Design - RT'}>}hrs) > 0, Sum(Complexity))/
Sum(TOTAL {<desc={'Design - IT',' Design - RT'}>}hrs)
Regards,
Jagan.
yeah..i have tried same exprn but its nt gvng correct
To use the indirect set analysis may be we get it