RE:Negative values ?

[Chanty4u]

Hi all,

Sunny T,Kush141087,Avinash R,pcammaert,jagan mohan rao appala,

below expression givng me negative values on my bar chart

Formuale:(No of Defects Fixed within 3 days from the date of defect opened / Total number of defects)*100

I want to caluclate % for <=1day

<=2Days

<=3Days

>3days

=Count({<Defect_Aging_Days='<=1'>}Def_ID)/num(count(Def_ID))*100

what wrng in my Exp?

Thanks in advance.

[sasikanth]

You can directly use

Count(Def_ID)/Count(Total Defect ID) for % of all ranges

else

you can use

Count({<Defect_Aging_Days={'<=1' ,'<=3'}>}  Def_ID)/count(TOTAL Def_ID)

for  specific

[Chanty4u]

not wrkng bro...kindly chk abve QVW

[sasikanth · Accepted solution]

hi,

PFA Application