Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In attached app when i was selecting only single value in "MonthYear" listbox, then in straight table chart "Stdev" expression is getting '-' value.
How i can resolve this issue and should get the value instead of '-'?
please provide your suggestion on this from anyone
Regards,
Satish
Hi Satish,
the fact is that RangeStdev of a single value is zero, or rather is not calculated, cause the value is equal to its avg.
I think you'd like to see '0' rather than '-'... well, I would do it brutally: if(rowno()=1,0,expr).
Greetings
IB