DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

Y axis range - Rounding Up

I am having an issue with setting the y-axis on my report.

 

I want to display a range of 300 on the y-axis.

- fixed numbers don't work.  depending on the data sets, the values can be anywhere from 0 - 5000.

- using the "range and tick" option doesn't work due to occasional spikes in the data.  (i.e.  most values are 200-500, but because of 2500 spike, range option sets y axis to 900-1200)

- i can use D2AxisYBegin, 'End, 'Origin.  I know how to set those using scripting.  So I found the median of the channel and want to round down to the nearest hundred and set that as my 'Begin so that I don't have weird 'Begin and 'End values.

 

Is there a way to round on the left side of the decimal?  (i.e. 1265 --> 1200)

 

0 Kudos
Message 1 of 2
(3,655 Views)

Please try this :

MsgBox(Fix(1265/100)*100)

0 Kudos
Message 2 of 2
(3,652 Views)