Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want not to show the empty and zero values from the chart.
I checked suppress zero values and suppress null values. But it is not working. Version is 11.0 SR2 64bit
Please help me.
Try this expressions
if(Floor(sum(COMM)) <>0 , sum(COMM))
OR
if(Round(sum(COMM)) <>0 , sum(COMM))
Regards,
jagan.
Hi Arjun,
I could not see any null/blank values in your chart.
I don't see it either
Can you post a screenshot of what you are seeing?
Hi,
Check whether you have floating point numbers like 0.00054. If you have like this Use Floor()/Ceil()/Round().
Regards,
Jagan.
Note: 0 <> 0.0000345 or any other number.
Regards,
Jagan.
Try this expressions
if(Floor(sum(COMM)) <>0 , sum(COMM))
OR
if(Round(sum(COMM)) <>0 , sum(COMM))
Regards,
jagan.