
Re: Straightchart presentation conditional Max number
Anne Duffy Jul 26, 2012 10:45 AM (in response to Anne Duffy)Actually now I think about it , its probably how I write the expressions
so sum Number only if Rank time is greater than 5
=sum(if(rank(sum(Number)*CycleTime/60)>5,Number))
I've tried the above  it doesnt work  any suggestions greatly appreciated
Thanks
A
Re: Straightchart presentation conditional Max number
Anne Duffy Jul 26, 2012 11:09 AM (in response to Anne Duffy)haha Me again
if(rank(sum(Number)*CycleTime/60)<6 or rank(sum({1}Number))<6,sum(Number),null())
The above works as in it will only sum when it is ranked in the Top 6 in either Rankings
But now is there a way to hide the row if the value is Null in the Sum Number column?
Thanks
A 
Re: Straightchart presentation conditional Max number
Anne Duffy Jul 26, 2012 11:09 AM (in response to Anne Duffy)haha Me again
if(rank(sum(Number)*CycleTime/60)<6 or rank(sum({1}Number))<6,sum(Number),null())
The above works as in it will only sum when it is ranked in the Top 6 in either Rankings
But now is there a way to hide the row if the value is Null in the Sum Number column?
Thanks
A 
Re: Straightchart presentation conditional Max number
Anne Duffy Jul 26, 2012 11:10 AM (in response to Anne Duffy)haha Me again
if(rank(sum(Number)*CycleTime/60)<6 or rank(sum({1}Number))<6,sum(Number),null())
The above works as in it will only sum when it is ranked in the Top 6 in either Rankings
But now is there a way to hide the row if the value is Null in the Sum Number column?
Thanks
A
