Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
am using pie chart expresions...
what wrong in my expression while caluculating the Def density
=(count( ref_ID)-sum(if(ref_Status='Dump' or reff_Status='Withd' or ref_Status='Rej',1,0)
/count(estatus='Passed')
Aceptance rate
=(count( ref_ID)-sum(if(ref_Status='Dump' or ref_Status='Withd' or ref_Status='Rej',1,0)
/count(ref_id)
please help me out...where am wrong
thanks in advance
Suresh
Your expression is wrong can you explain with fields and flag fields in the formula that you want to achieve.
Regards
Anand
Names are case-sensitive and you have also misspelt one in your example.
Try this once or provide sample data file
I assume here that you want to subtract that value which contains ref_Status='Dump' or ref_Status='Withd' or ref_Status='Rej'
=(count(ref_ID) - sum(if(ref_Status='Dump' or ref_Status='Withd' or ref_Status='Rej',1,0))
/
count(ref_id))
Regards
Anand
may be this:
=(count( ref_ID) - sum(if(ref_Status='Dump' or reff_Status='Withd' or ref_Status='Rej',1,0))
/
count({<estatus={'Passed'}>} ref_ID)
or try with distinct:
=(count(distinct ref_ID) - sum(if(ref_Status='Dump' or reff_Status='Withd' or ref_Status='Rej',1,0))
/
count({<estatus={'Passed'}>} distinct ref_ID)
This is maybe the most readable way to get the result you want:
Count({$<ref_Status -={'Dump','Withd',Rej'}>}ref_ID)/Count(ref_id)