Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my data set i have zero values, i want to display smallest 15 average. in that list there may be zero values.
I want to ignore them and display smallest values exclude zeros. i have checked dimension limits, but it is not working.
Please help me.
Thanks
hi,
Not sure what u mean by smallest 15 avg. But if u want to display the smallest value ignoring zeros then try using the set:
e.g: =min({<val-={0}>}val)
where val can be 3,4,5,0,0,0 ,etc
in the above case the result will be 3 and not 0.
Please let me know if this helps.
presentation of chart-> supress zero values
hope this helps
Hi when i select supress Zero values ,
when i select show smallest 15 values and my data set has 10 zeros, it only display 5 values in the bar chart.
Thanks,
Hi,
In the script, once again resident load the field whatever you are using in your expression, and give where condition as:
load
<your field name>
resident .......
where <your field name> <>0;
hope it will work.
Ananth