Re:Sum and exclude '"0"

[Chanty4u]

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

[Chanty4u]

not wrkng sudhakar

[Chanty4u]

no luck......

[#4]

and what output is giving insted of all use total

[Chanty4u]

both are nt gvng exact values ....

[jagan]

Attach sample file then it would be easier to understand and provide the solution.

Regards,

Jagan.

[Anonymous]

sum( {<hrs={'*'}>}-e(hrs={'0'})hrs)

try it this one

[Chanty4u]

....   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)

[jagan]

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.

[Chanty4u]

yeah..i have tried same exprn but its nt gvng correct

[Anonymous]

To use the indirect set analysis may be we get it