Error in exp

[Chanty4u]

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

[#2]

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

[maxgro]

count({$ <Def_Status={Reop}>} Def_Status) / count( {$ <ref={Open,New,Assigned}> } ref)

[Chanty4u]

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

[Chanty4u]

it is not wrkng maxgro...

[manojkulkarni]

can you post some sample data

[Kushal_Chawda]

(sum(if(Def_Status='Reop',1,0))/sum(if(ref='Open' or ref='New' or ref='Assigned', 1,0)))*100

[Chanty4u]

its nt wrkng kush..

[jagan]

Hi,

Try this

=(count({<def={"Reopen"}>} def) / count({<def={"Open","New","Assigned"}>} TOTAL def) )*100

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi Suresh,

Is it Reopen or Reop, correct it accordingly.

Regards,

jagan.