Home -
General /
All posts - Percentage values in Active Columns stop at 100 % ? Is this normal behaviour ?
|
I found a strange behaviour - probably a bug - in Active Column calculations. Using 'Percentage' for the Active Column 'RatioAreaLength' values stop at 100 % even if the ratio is over 100%. The VbScript I use for the "active Column" is Function Ratios Ratios = Record.Data("Area (I)") / Record.Data("Length (I)") End Function Using Floating-point show the right Ratio value though ! See picture hereafter. Is this normal - well known - behaviour using 'Percentage' ?
|
|
I don't think so. Do you have a data sample to try? I can't reproduce this. Thanks.
Stay connected: Linkedin >> http://www.linkedin.com/in/gustavopalminha Twitter >> http://twitter.com/gustavopalminha Other >> http://www.spatialmentor.com |
|
It does look like a bug (or an "unexpected feature"). It also applies to ordinary (non-active) columns. E.g. if a floating-point column is converted to a percentage column, values greater than 1 are clipped to 100%. I hope you report this to Tech. In the meantime it's easy enough to make your own percentages in a floating-point column of course.
|
|
Values in Percentage columns are from 0% to 100%, that's by design. If you don't want automatic range restriction, you can use Double / Single and format the result as a percentage, perhaps using an active column.
|
|
Adam, Good to remind me of this. Thank you.
|
|
And sorry yes, ahem, I should have looked.
|