Subscribe to this thread
Home - General / All posts - Percentage values in Active Columns stop at 100 % ? Is this normal behaviour ?
yves61
438 post(s)
#02-Mar-15 07:18

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' ?

Gustavo Palminha

1,010 post(s)
#02-Mar-15 09:30

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

yves61
438 post(s)
#02-Mar-15 12:09

Here you are, some data to test.

percentageActiveColumn.map

Attachments:
percentageActiveColumn.map

tjhb
10,094 post(s)
#02-Mar-15 20:08

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.

adamw


10,447 post(s)
#03-Mar-15 07:22

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.

yves61
438 post(s)
#03-Mar-15 09:34

Adam,

Good to remind me of this. Thank you.

tjhb
10,094 post(s)
#03-Mar-15 11:22

And sorry yes, ahem, I should have looked.

Manifold User Community Use Agreement Copyright (C) 2007-2021 Manifold Software Limited. All rights reserved.