Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to know if there is a way to ensure that the bars having zero values be made invisible .
I do understand by converting the zero to Null we can have this achieved, but i would want to retain the zero Values as it is required for me to go ahead with the other column calculations using the previously calculated values
Try by giving a decimal value to the Zero's
example
if( Sum(Sales)=0,0.01,Sum(Sales))
Hi Vineeth,
The requirement is not to see those bars so this would not work
it will only be visible if you scale is in 2 decimals IS IT??