Hi All,
I have the following calculation working fine in Table Chart, but not in Line Chart. Can you please let me know
=(
if((if(isnull(e1),0,1) + if(isnull(e2),0,1) + if(isnull(e3),0,1))=0,0, ((sum(e1) + sum(e2) + sum(e3)) / (if(isnull(e1),0,1) + if(isnull(e2),0,1) + if(isnull(e3),0,1)))) +
if((if(isnull(f1),0,1) + if(isnull(f2),0,1) + if(isnull(f4),0,1))=0,0, ((sum(f1) + sum(f2) + sum(f4)) / (if(isnull(f1),0,1) + if(isnull(f2),0,1) )))
)
/
(
if((if(isnull(e1),0,1) + if(isnull(e2),0,1) + if(isnull(e3),0,1))=0,0,1) +
if((if(isnull(f1),0,1) + if(isnull(f2),0,1) + if(isnull(f4),0,1)) =0,0,1)
)
