Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following script for calculating a class:
=Dual(Replace(Class(Amount,10), '<= x <', ' - '), Class(Amount,10))
I get the following chart:
How do i change the script to get rid of the highlighted negative class?
Regards.
Chris
Did not test but may be try this?
=Dual(Replace(Class(IF(Amount>0, Amount),10), '<= x <', ' - '), Class(Amount,10))
Did not test but may be try this?
=Dual(Replace(Class(IF(Amount>0, Amount),10), '<= x <', ' - '), Class(Amount,10))
Thank you very much Vishwarath, most appreciated.
Regards.
Chris