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]

i have two exp ....numerator and denomenator......in ur exp both exp are same?

[dinuwanbr]

Hi,

Can you upload a sample?

BR,

Dinu1

[#4]

try it like this f(sum({<desc={'Design - IT',' Design - RT'}>}hrs)>0,sum(Complexity)/sum({<desc={'Design - IT',' Design - RT'}>}hrs))

[Chanty4u]

no nishit...its nt wrkng....its gvng wrng values....

i want only....

sum({<desc={'Design - IT',' Design - RT'}>}hrs)

this values  other that zero--->corresponding values      

there is 47 value.. corresponig 172...   the result shud be   172/408.  is my result.

[#6]

then try it like this if(sum({<desc={'Design - IT',' Design - RT'}>}hrs)>0 and sum(Complexity)>0,sum(Complexity)/(sum({<desc={'Design - IT',' Design - RT'}>}all hrs))

[HirisH_V7]

Hi ,

Please check the attached app . if you want to do any modifications regarding data you can . then we can check the result.

-Hirish

[Chanty4u]

no hirish,

actual my exp is:

=sum(Complexity) / sum({<desc = {'Design - IT', 'Design - RT'}>} TOTAL hrs)

i hve taken in stright table   both expressin as one -one exp..

the abe exp gvng sum of compl / sum that value....no issues

but i want only the corresponding values of denominater value .

:there is 47 value.. corresponig 172...   the result shud be   172/408.  is my result.

172 value is  sum(cmp)  / 408  means    sum({<desc={'Design - IT',' Design - RT'}>}hrs)

[sunny_talwar]

May be this:

If(Sum({<desc={'Design - IT',' Design - RT'}>}hrs) > 0, Sum(Complexity)/Sum(TOTAL {<desc={'Design - IT',' Design - RT'}>}hrs))

[HirisH_V7]

Hi,

Check this,Hope this helps your requirement,

PFA

-Hirish

[Chanty4u]

thnx sunny the exp fyn enough...

but one more thing i need in this...............

both exp zero values shud nt be considered   and remaing values shud be summed in  frst exp/total