Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
below is my result formulae and i used exprsn ...
( No of Defects Re-op / Total No of ref fixed ) * 100
used exp: =num(Def_Status='Reop')/sum(if(ref='Open' or ref='New' or ref='Assigned', 0,1))*100
it shwng exprn Ok... but pie chrt values or not getting..
Error message:no data to dispaly
please help me the expression
Thanks in advance
Suresh
Hi, your expression is wrong. You need count the least granular Dimension that have bithe Def_status & ref values
(count({<Def_status={"Reop"}>} Dimension_Field) / count({<ref-={"Open","New","Assigned"}>} Dimension_Field) )*100
count({$ <Def_Status={Reop}>} Def_Status) / count( {$ <ref={Open,New,Assigned}> } ref)
hi dattu,
thanks for the reply it shwng the value as ''0''
(count({<def={"Reopen"}>} def) / count({<def={"Open","New","Assigned"}>} def) )*100
i need denomenator as total num of.... if we use count for numerator it is shwng '0'
thanks in advance
it is not wrkng maxgro...
can you post some sample data
(sum(if(Def_Status='Reop',1,0))/sum(if(ref='Open' or ref='New' or ref='Assigned', 1,0)))*100
its nt wrkng kush..
Hi,
Try this
=(count({<def={"Reopen"}>} def) / count({<def={"Open","New","Assigned"}>} TOTAL def) )*100
Hope this helps you.
Regards,
Jagan.
Hi Suresh,
Is it Reopen or Reop, correct it accordingly.
Regards,
jagan.