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
i have two exp ....numerator and denomenator......in ur exp both exp are same?
Hi,
Can you upload a sample?
BR,
Dinu1
try it like this f(sum({<desc={'Design - IT',' Design - RT'}>}hrs)>0,sum(Complexity)/sum({<desc={'Design - IT',' Design - RT'}>}hrs))
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.
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))
Hi ,
Please check the attached app . if you want to do any modifications regarding data you can . then we can check the result.
-Hirish
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)
May be this:
If(Sum({<desc={'Design - IT',' Design - RT'}>}hrs) > 0, Sum(Complexity)/Sum(TOTAL {<desc={'Design - IT',' Design - RT'}>}hrs))
Hi,
Check this,Hope this helps your requirement,
PFA
-Hirish
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