RE:what wrng in my exp?

[Chanty4u]

hi all,

Sunny T

am caluclating the agebands in weeks,

like

>3days

<=1day

<=2Days

<=3Days

my exps

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

it is shwng ok.. but the thing where am shwng dese values in'' %    ''  it is nt gvng 100%...it total count gvng only 92%lik dat

why it is any idea

thanks

Suresh 

[Chanty4u]

thnx sunny...when i select relative...it is shwng 1005...but in chrt also am getting another bar as shwng total label aswell?

[sasikanth]

IF possible share your sample file , it would be easy to find out the issue

[Chanty4u]

yes even though it is shwng same

[Chanty4u]

chk attached image shwng reltve selctd..it is shwng same vlues tooand extra legend total also

[sasikanth]

if you are also using Defect_aging_days also as a dimension then

try to suppress null values option in dimension tab.

try once

[Chanty4u]

yes ihve tried still same it is shwng

[sasikanth]

Please do share your qvw